topic Re: show location when two products exist in QlikView

show location when two products exist

Anonymous — Mon, 11 Mar 2013 23:31:58 GMT

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)

Re: show location when two products exist

Tue, 12 Mar 2013 00:02:59 GMT

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

Re: show location when two products exist

MayilVahanan — Tue, 12 Mar 2013 00:11:36 GMT

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