topic Re: Help with Set analysis in QlikView

Help with Set analysis

Wed, 29 Jul 2015 10:27:53 GMT

Hello,

excuse me but I have another problem with set analysis.

I need to calculate in a table an expression to have the percentage of Sales for each item to total.

Please can you help me?

Thnak you very much.

Best regards.

sunny_talwar — Wed, 29 Jul 2015 10:28:51 GMT

This won't require set analysis. Try something like this:

Sum(Sales)/Sum(TOTAL Sales)

Anonymous — Wed, 29 Jul 2015 10:29:20 GMT

Hi,

if I understand right try with this:

sum({1}SalesAmount)/sum({1}Total SalesAmount)

Regards

sorrakis01 — Wed, 29 Jul 2015 10:29:39 GMT

Hi,

Sum(Sales Item)/Sum(TOTAL Sales Item)

Regards

sushil353 — Wed, 29 Jul 2015 10:30:59 GMT

Hi,

Simply select the option Relative for the particular expression

Wed, 29 Jul 2015 10:31:12 GMT

Yes!

Thank you very much!

Best regards!