I need to know how I can create the following solution in Qlikview.
I have alot of data, therefor I have alot of pivot tabels to simplify the data.
However, I need to add the relative pct. to the tabel - so far without luck.
How can I get my qlikview pivottabel to act as the Excel screenshots below;
Thanks in advance to all of you
I know how to make pivot tabels in Qlikview - that was not the question.
The questions was as to how I can make the percentage calculation as shown in the Pictures.
I your Sum(Sales) or Sum(total Sales) are callculated in other expressions of the same chart, You may use thems results in another expression (almost like in xls) . U may call it by name (label).
Some types of charts have "Relative" option. But pivot has not.
I think it is not possible to show values if it has not expression. You most often need also dimension (s) .
Sometimes it may be useful to add artificial dimension to have less expressions. But i don't understand what is the problem of having 1 more epression in your chart?