topic Re: Top Values in Straight Table in QlikView

Top Values in Straight Table

Wed, 13 Jan 2016 20:10:40 GMT

I have an expression like sum(x+y+z) on top of that how get top 0-2% 3-5% 6-10% values in straight table.

Thank you

Message was edited by Community Moderator for clarity

sunny_talwar — Wed, 13 Jan 2016 21:25:46 GMT

Not sure what you mean? Would you be able to provide a sample with your expected output?

Wed, 13 Jan 2016 23:25:08 GMT

When i select the invoice, i have the first option approve application for lunch ? i select yes, and i have the next error Failed to lunch

PradeepReddy — Thu, 14 Jan 2016 05:04:59 GMT

might be helpful..

HirisH_V7 — Thu, 14 Jan 2016 06:02:25 GMT

Hi,

May be like this,

Straight Table->

Dimension- Product

Expression -

1) Sum(Aggr(Sum(Sales)/Sum(Total Sales),Product))

2) IF(Sum(Aggr(Sum(Sales)/Sum(Total Sales),Product))*100>=0 and Sum(Aggr(Sum(Sales)/Sum(Total Sales),Product))*100<=2,'1%-2%',

IF(Sum(Aggr(Sum(Sales)/Sum(Total Sales),Product))*100>=2 and Sum(Aggr(Sum(Sales)/Sum(Total Sales),Product))*100<=4,'2%-4%','>5'))

And in Dimension Limits you can keep largest 10 Values as per your requirement.

Hope this Helps,

PFA,

Hirish.v