topic Previous Month Value in QlikView

Previous Month Value

Fri, 05 Dec 2014 13:17:08 GMT

Hi Friends,

We have a requirement to show month-3 value (Ex: If June is selected then we want to show Mar month value). Below expressions are used and value is displayed in a separate column whereas requirement is this value need to be displayed in the same column as other measures. Attaching the screenshot for reference.

sum({<MonthYear={'$(vYear3)'},Month_Name=>}Revenue)

vYear3= Date(AddMonths(max(Date),-3),'MMM YYYY')

2912 value is correct but we require it in June column instead of March column(which is getting created as a separate column.

Thanks in Advance,

Siva Srinivas.

Re: Previous Month Value

Anonymous — Fri, 05 Dec 2014 13:49:27 GMT

Hello,

The issue is about your dimension. It should work without it.

It is normal because QV cannot show a dimension's value under another value.

Serhan

Re: Previous Month Value

Anonymous — Fri, 05 Dec 2014 13:59:08 GMT

You need to write different expression for each column.

Serhan