topic Re: 12 Months Set Analysis in QlikView

12 Months Set Analysis

Anonymous — Thu, 18 Oct 2018 17:19:06 GMT

Trying to show the some for the past 12 months based on the current selections .

Dimension : YearMonth

Expression :

sum({[Year & Month]=,[Fiscal Year]=,[Date ]= {">=$(=vMinDate) <=$(=vMaxDate)"}>}[Amount])

The result is if I select yearmonth = aug18 it shows the sum of all possible from aug18 to the very last month in the QVdD. Even though I am limiting the Date to 12 months using the min amd max.

How can I show only the last 12 months?

Re: 12 Months Set Analysis

Anonymous — Thu, 18 Oct 2018 18:12:17 GMT

Changed the expression order for modifier and it worked :

sum({[Date ]= {">=$(=vMinDate) <=$(=vMaxDate)"},[Year & Month]=,[Fiscal Year]=,>}[Amount])

Re: 12 Months Set Analysis

lironbaram — Thu, 18 Oct 2018 18:19:40 GMT

what expressions are you using in the variables