topic Re: Rolling Month in Set analysis expression excluding Month Selection in QlikView

Rolling Month in Set analysis expression excluding Month Selection

rsdhavle — Wed, 07 Dec 2016 16:03:08 GMT

I have to calculate data for rolling 12 months in a variable and this variable value should not change based on field Month selection. Currently when i am selecting a Month in a field it is changing.

Re: Rolling Month in Set analysis expression excluding Month Selection

robert_mika — Thu, 08 Dec 2016 01:22:38 GMT

Try use Month=

in your set analysis to ignore selection in the Month dimension.

like:

sum({<Month =, }fieldname)

Re: Rolling Month in Set analysis expression excluding Month Selection

sunny_talwar — Thu, 08 Dec 2016 03:41:19 GMT

What is your expression right now?

Re: Rolling Month in Set analysis expression excluding Month Selection

rsdhavle — Fri, 09 Dec 2016 13:26:03 GMT

SUM({<Year=,MONTH=,YearMonth={'>$(=Max(YearMonth)-100) <=$(=Max(YearMonth))'}>}Revenue)

This is my current expression somehow even after exculding Month, it changes based on Month selection.

Is it because of YearMonth range i have defined in the expression

Re: Rolling Month in Set analysis expression excluding Month Selection

sunny_talwar — Fri, 09 Dec 2016 13:34:36 GMT

May be this:

Sum({<Year=, MONTH=, YearMonth = {'>$(=Max({<MONTH=>} YearMonth) - 100)<=$(=Max({<MONTH=>} YearMonth))'}>} Revenue)

Re: Rolling Month in Set analysis expression excluding Month Selection

robert_mika — Fri, 09 Dec 2016 13:35:24 GMT

Qlikview is case sensitive.

Is MONTH in set analysis = Month in Listboxes?