topic Re: Showing top 20 amount in QlikView

Showing top 20 amount

narender123 — Wed, 25 Sep 2013 06:12:11 GMT

Hi All,

I have created a table with 5 expression and 2 dimention.In these expression am am showing the top 20 amount value by set the dimention limit tab and select top 20 with global grouping mode.if i use my 1st expression as amount then its shows top 20 amount but when i shifted this expression amount info 3rd expression means not 1st expression then its showing top 20 amount with some 0 vale???

Can anyone tell me what is wrong with using the expression as 3rd expression not 1st one.

id name amount cif sum

1 aa 100 200 150 (ok when amount is 1st exp.)

id name cif sum amount

1 aa 200 150 100

---

0 ( showing 0)

Thanks

Re: Showing top 20 amount

Oleg_Troyansky — Wed, 25 Sep 2013 06:27:25 GMT

Dimension Limits only work on the first Expression, that's just the way it works...

I can recommend my recent blog about showing top values:

QlikView Blog Q-Tip #5 – Show Top Performers. Common but not too trivial. | Natural Synergies

cheers,

Oleg Troyansky

www.masterssummit.com

Re: Showing top 20 amount

abeyphilip — Wed, 25 Sep 2013 06:35:28 GMT

Hi Narendar,

Is it possible that your sorting expression got changed after changing the expression sequence?

In that case if your top 20 is based on amount, then you may have to explicitly set that in sort tab.

Regards,

Abey

Re: Showing top 20 amount

jagan — Wed, 25 Sep 2013 06:39:59 GMT

Hi Narendar,

The Top N is arrived based on the Sort tab settings. Check Sort tab.

Regards,

Jagan.

Re: Showing top 20 amount

narender123 — Wed, 25 Sep 2013 06:44:12 GMT

Thanks for the reply Abey and Jagan.

Yes you are right.

Initially i have set this based on sort tab by taking amount as sort 1st in decrement order.

with this setting its showing some 0 amount which is not possible.

But when i am taking this amount as 1st expression as well as in sort tab taking ammount in topthen it doesnt not 0.

Why??

Thanks

Re: Showing top 20 amount

abeyphilip — Wed, 25 Sep 2013 06:49:45 GMT

Narendar,

You are defining the priority for sorting in the sort tab by moving it up or down.

So when you were getting 0s for amount, it was getting sorted using some other value than Amount.

And when you set Amount as the top priority, it was actually sorting using Amount value in descending.

regards,

Abey

Re: Showing top 20 amount

narender123 — Wed, 25 Sep 2013 07:07:11 GMT

I have set the amount as top one in sort tab by decending order but still showing 0. But 0 is not possible.

Thanks.

Narender