Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jhlovenc
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

Re: show location when two products exist

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
Not applicable

Re: show location when two products exist

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