Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

show location when two products exist

I want an expression in a  chart that only flags Location_ID_Key if the location has two products, HEM and PSL.  Below does not work.  count({} DISTINCT Location_Id_Key)

2 Replies
Not applicable
Author

Hi

Please apply below formula with your field name in Expression and check if the location id is coming where location has 2 products.

 

IF(AGGR(COUNT(Location),Product)<2,0,AGGR(COUNT(Location),Product))

I guess it will help you.

Regards,

~Vinod

MayilVahanan

hi

Trylike this

count({<product={'PSL'}>*<product={'HEM'}>} DISTINCT Location_Id_Key) //this count the location id key where product contain both psl and hem..

hope it  helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.