Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a nice problem:
There is a table (diagram) containing a number of rows, a dimension and a percentage:
Account | Percentage |
---|---|
A | 50% |
B | 30% |
C | 60% |
What I want to see, is the product of all percentages (50% x 30% x 60% -> 0.5 x 0.3 x 0.6 -> 0.09 -> 9%) as a column:
Account | Percentage |
---|---|
A | 9% |
B | 9% |
C | 9% |
How can I achieve this?
Thanks a lot in advance,
Martin
You could try something like
=exp(sum(total log(Percentage)))
as expression in your chart.
And maybe you want to vote for http://community.qlik.com/ideas/1105
Regards,
Stefan
Hi Stefan,
thanks, but this only gives me 100% for all rows...
And i voted.
Martin
See attached for a sample.
How do you calculate your percentage?
Stefan
If I would get the product of all percentages as a total row it would also be ok:
Account | Percentage |
---|---|
A | 50% |
B | 30% |
C | 60% |
Total | 9% |
Thanks,
Martin
Hi,
my percentage is something like "sum(CounterM) / sum(VK_MENGE)"
Thanks,
Martin
Then try something like
exp(sum(total aggr(log(sum(CounterM) / sum(VK_MENGE)),Account)))
Hmm... like that I get only 0% everywhere... and when I use another expression with "sum(CounterM) / sum(VK_MENGE)" as xxx and use the result of this in the main formula "exp(sum(total aggr(log(xxx),Account)))", I get a 100% everywhere... can you see my mistake?
Some more examples.
Stefan
Could you upload a simplified version of your app here in the forum? Or just some LOAD INLINE tables as text?