topic Re: Top 5 in QlikView

Top 5

master_student — Wed, 29 Jun 2016 12:11:33 GMT

Hi guys,

I need to display the top 5 amount without using sum function. My expression is : sum( {< [Year of date]=, [Month of date]=, [Day of date]=,Dis_name =>} BALANCE/1000) because the amounts are wrong using the sum function.

a print screen of my graph :

Is that possible?

Thanks in advance

Re: Top 5

sunny_talwar — Wed, 29 Jun 2016 12:13:19 GMT

What exactly are you trying to do? May be use Only? I don't know much to offer much suggestions...

Re: Top 5

jonathandienst — Wed, 29 Jun 2016 12:14:52 GMT

I think you need to explore why the number is wrong using the sum function. Working around may be treating the symptom, but not the underlying cause.

Anyway, it is not possible to make suggestions without a lot more information.I suggest that you post your qvw, or a sample that illustrates the problem.

Re: Top 5

Wed, 29 Jun 2016 12:46:07 GMT

As Jonathan mentioned, tough to diagnose without more information...but assuming you do figure out your SUM issue I believe you can achieve the top 5 using Dimension Limits. In your case you would restrict the values displayed by showing only the largest 5.

Re: Top 5

master_student — Wed, 29 Jun 2016 12:52:23 GMT

I don't know but by using the sum function in the expression. The amounts displayed are not correct. I just need to display the amount like they in the database and use only the num function : =num(BALANCE/1000, '# ##0')

Thanks a lot

Re: Top 5

master_student — Wed, 29 Jun 2016 12:55:25 GMT

I already created my top 5 graph using dimension limit but the pb is that with the sum function the amounts are too big.

Re: Top 5

susovan — Wed, 29 Jun 2016 12:56:23 GMT

Hi,

You can try this,

Re: Top 5

sunny_talwar — Wed, 29 Jun 2016 13:40:45 GMT

Have you tried this:

=Num(Only({<[Year of date], [Month of date], [Day of date],Dis_name>} BALANCE/1000), '# ##0')

Re: Top 5

master_student — Wed, 29 Jun 2016 14:40:47 GMT

Hi Sunny,

it didn't work