Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

fahuruba
Contributor

Ignore Dimensions in chart set analysis

Good Day ,

I have a straight table with thse figures:

dimension :  Month

expression count(ID)

Chart 1:  

MonthTotal
Jan10
Feb12
Mar14

Now i want to ignore the Dimension using set analysis

so that my end result is like this :

  

Month PrevMonTotal
Jan0
Feb10
Mar12
Apr14

thanx in advance

1 Solution

Accepted Solutions
Employee
Employee

Re: Ignore Dimensions in chart set analysis

The Set Analysis is global for the chart - i.e. it is not evaluated row-by-row. The best way to solve this problem is to use

     RangeSum(Above(Count(ID)))

Then you get the value from previous row.

HIC

1 Reply
Employee
Employee

Re: Ignore Dimensions in chart set analysis

The Set Analysis is global for the chart - i.e. it is not evaluated row-by-row. The best way to solve this problem is to use

     RangeSum(Above(Count(ID)))

Then you get the value from previous row.

HIC

Community Browser