Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

How to show certain values in a List Box??

=if((count({$< [Product ID]={"=count ({< Status={ACTIVE} >}DISTINCT UPC_CODE)=2"}>} Distinct [Product ID])-

count(Aggr(IF(COUNT(DISTINCT UPC_CODE)=2 and Status='ACTIVE',[Product ID]),[Product ID])))=1,[Product ID])

How to show only those values in a list box that satisfies the above condition? So  my expression calculates

the number of productID when AGGR Exp is subtracted from Set Analysis Exp. What I need is to identify Product IDs

that are not captured by AGGR function. It is working ok when I put the above Expn in the Expression of list box

and sort it by Expression. But what I really need is for the list box to show only those Product IDs that are not

captured by AGGR function, which is the same as satisfying the expression I have above.

1 Reply
Highlighted
Specialist
Specialist

anyone? swuehl‌ or sunindia‌ ??