calculated filter

[praju179396]

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;

------------------------------------------------------------------------------------

[edwin]

you posted in qlikview and your question is for qlik sense.  the two have different UI properties.  also, adding sample data + expected results would work best.  its hard imagining the data and what you want to happen with very limited info.