topic Re: Percentage in Dimension in QlikView

Percentage in Dimension

Thu, 03 Sep 2015 13:14:06 GMT

Hello,

Using this expression i get this table:

sum(SALES)/ sum(total(SALES))

What i need is to separate the percentage by dimensión DATE

Could you help me please?

Thanks

alexandros17 — Thu, 03 Sep 2015 13:16:07 GMT

Could you send an example

saurabh5 — Thu, 03 Sep 2015 13:19:02 GMT

hi Belen,

I am little confused with your requirement is your ask to change the label of distribution dimension to date?

Thu, 03 Sep 2015 13:24:09 GMT

In the first chart the sum of the percentages is 100%.

What i need is the weights in the dimensión "date": in each column. Is this posible?

I do not know if i explain myself well......

Thu, 03 Sep 2015 13:31:03 GMT

alexandros17 — Thu, 03 Sep 2015 13:53:49 GMT

Try with this expression:

Sum(Sales)/Sum(Aggr(Sales, Distribution,Date))

let me know

ChiragPradhan — Thu, 03 Sep 2015 13:55:33 GMT

Hi Belen,

Use this expression Sum(Sales)/Sum(TOTAL<Company> Sales).

Regards

Chirag.

Thu, 03 Sep 2015 13:56:41 GMT

Thanks