topic Set Analysis - Help Needed in QlikView

Set Analysis - Help Needed

Anonymous — Sat, 06 Feb 2010 18:45:50 GMT

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

Set Analysis - Help Needed

johnw — Sat, 06 Feb 2010 20:48:26 GMT

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.

Set Analysis - Help Needed

Anonymous — Sat, 06 Feb 2010 20:54:32 GMT

THANKS !! It works

Also thanks for the "%" tip

Nils