=Aggr(Only({<year={$(=Concat(Distinct Chr(39)&[dataset.Year]&Chr(39),','))}>}year),year)
May 1, 2023
Apr 11, 2023
QlikSense between two selected Range. using set analysis expression
=Avg({<gender={'Male'},country={'$(tCountry)'},age={">=$(tSlide1)<=$(tSlide2)"}>}value)
Mar 22, 2023
Hide/show field based on dropdown selection in QlikSense
Inline table in the query editor for drop down static list:
Scenario_Comp_Filter:
Load * inline [
MID,Measure
1,"Sales"
2,Percentage
];
Dropdown selected values in the aggreegate.
If(GetSelectedCount(Measure)=0,Num(Sum([Sales]),'#,##0'),
Pick(Match(MID,'1','2'),
Num(Sum([Sales]),'#0.00%'),
Num(Sum(Percentage),'#,##0'),
//Num(Sum([Sales]),'$###,##0'),
))
Use below expression in Show condition of the field.
If(GetSelectedCount([Level 1]) > 0 ,$(=SubStringCount(Concat([Level 1],'|'),'Field1')),0)
Oct 27, 2021
Power BI filter using URL parameter
https://app.powerbi.com/groups/9xyz64-xyzd-xyz5-xyz8-cfx/reports/9xyz64-xyzd-xyz5-xyz8-cfxyzdexyz/ReportSectiondxyz?filter=TableName/FielName eq 'Boo'
Dec 14, 2020
Spotfire Hide show control based on list box selection
$("#showHidecontainer").hide();
$('#Ant').click(function(){
var PrdVal = $("#Ant .sfpc-selected").text();
if (PrdVal == "Test")
{
$("#showHidecontainer").show();
}
else
{
$("#showHidecontainer").hide();
};
});