topic Re: Need Logic help in QlikView

Need Logic help

lalitkgehlot89 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In given data i want to show top 3 storeid of each businessline with Netamount.

Please help me out.

Regards,

Lalit Kumar

varshavig12 — Thu, 08 Sep 2016 11:20:25 GMT

Try using Rank()

florentina_doga — Thu, 08 Sep 2016 11:31:39 GMT

see attach

tresB — Thu, 08 Sep 2016 11:34:06 GMT

PFA

lalitkgehlot89 — Thu, 08 Sep 2016 11:36:26 GMT

no attached file found.

lalitkgehlot89 — Thu, 08 Sep 2016 11:36:35 GMT

no attached file found.

sujayrpatil — Thu, 08 Sep 2016 11:40:24 GMT

Hi lalit ,

You can use the below condition to get top 3 net values of Businessline.

=if(Rank(aggr(sum(NetValue),BUSINESSLINE))<=3,aggr(Sum(NetValue),BUSINESSLINE))

Chanty4u — Thu, 08 Sep 2016 12:06:23 GMT

Please open your thread in new tab u can able to find the attachments

santiago_respane — Thu, 08 Sep 2016 12:12:26 GMT

Hi, you need to create a chart, add businessline and storeid as dimension and then use an expression like this:

if(rank(sum(NetValue))<4,sum(NetValue))

Please let me know if this helps.

Kind regards,

HirisH_V7 — Thu, 08 Sep 2016 14:25:37 GMT

Hi,

Check this,

=IF(Rank(Aggr(Sum(NetValue),StoreID,BUSINESSLINE))<4,Sum(NetValue))

HTH,
Hirish