topic Relative percentages within chart dimension in QlikView

Relative percentages within chart dimension

Anonymous — Sat, 07 Apr 2012 09:50:19 GMT

This is probably really simple but i can't seem to find the solution.

Below on chart 1 I would like each Type to be on a scale of a 100%. If i drill down, chart 2, I get what I would like at the higher level. I have selected "relative", and the formula is a sum of an amount that can be positive or negative. Each negative will have a corresponding positive, so i would like the % of negatives & positives.

Re: Relative percentages within chart dimension

goldnejea8 — Mon, 09 Apr 2012 20:42:43 GMT

The relative option shows the percent as compared across your entire dimension (type) set.

Try doing something like this:

sum(fabs(Amount))/aggr(nodistinct sum(fabs(amount)),type)

De-Select the relative option, and on the numbers tab, choose Number and select Show in Percent (%)

qlikuser14 answered this question in this post:

http://community.qlik.com/message/202415