calculated filter

praju179396 — Wed, 04 May 2022 14:30:07 GMT

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;

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

Re: calculated filter

edwin — Tue, 10 May 2022 21:31:22 GMT

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.

topic Re: calculated filter in QlikView

calculated filter

Re: calculated filter