Hello
I want to create a list box filter in Qlik sense frontend by using count .
The expression I have used in set analysis :
count(distinct {<TurnoverValue={>0"}>}Premise_ProductServiceLine)
The same count I am expecting from load script to create a filter on frontend as per premisekey , so I have used below script :
Service_Line_Count:
Load
PremiseKey,
count(Distinct Premise_ProductServiceLine) as [Service Line Count1]
group by
PremiseKey;
Load Premise_ProductServiceLine,
PremiseKey,
Key
Resident Dimension;
Inner Join
Load Key
Resident Measures
where TurnoverValue > 0;
------------------------------------------------------------------------------------
