Set Analysis - Help Needed

[Anonymous]

Hi,

Using Set Analysis, I would like to show the following in a Line Chart:

Trend in sales over the year in percent compared to January sales, but I have 2 problems in making it work.

If January is not selected, the expression isn't shown at all.

If January is selected, the expression is only shown in January.

The expression is like this: (sum(Sales) / sum({<Month={1}>} Sales)) * 100

Please download the attached qvd to see the problem.

First select month 2 and 3 - no percent shown

Next, select month 1, 2 and 3 - percent shown in month 1… not in month 2 and 3

Best regards

Nils

PS! I found the example qvd in another post and modified it to show my problem - thank you

[johnw · Accepted solution]

When you're in a chart, each row is still restricted by the dimension value(s), even when you use set analysis. So you need the "total" keyword, which tells QlikView to IGNORE the row's dimension value(s).

(sum(Sales) / sum({<Month={1}>} total Sales))*100

As an aside, I would normally show a percentage by just selecting "Show in Percent (%)" on the Number tab.

[Anonymous]

THANKS !! It works

Also thanks for the "%" tip

BR

Nils