May 1, 2023

Qliksense apply filter to only one chart on the sheet

 Expression: 

Sum({<[dataset.field1]={'$(=GetFieldSelections([FilterOne]))'},[dataset.Year]={$(v_YEAR_FILTER)}>} [dataset.sales])


v_YEAR_FILTER  is variable which holds expression of unique value. 


v_YEAR_FILTER=Concat(Distinct If(Len(Trim(Aggr(Only({<year={$(=Concat(Distinct Chr(39)&[dataset.Year]&Chr(39),','))}>}year),year))) = 0,Null(),Chr(39)&Aggr(Only({<year={$(=Concat(Distinct Chr(39)&[dataset.Year]&Chr(39),','))}>}year),year)&Chr(39)),',')


QlikSense Casecade/ display only available values based on previous filter selection

 =Aggr(Only({<year={$(=Concat(Distinct Chr(39)&[dataset.Year]&Chr(39),','))}>}year),year)