topic Re: Getting previous quarter value showing current quarter in dimension in QlikView

Getting previous quarter value showing current quarter in dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have taken sample QVW from one of discussion.

I need selected dimension with previous quarter value in expression. When I use previous quarter in expression dimension is also changing to previous quarter.

So in example I have selected 3 but selected quarter is showing as 2.

I have many dimesions, if I use getselectedvalue function it in dimension not working in some cases.

Regards,

Sai Krishna.

Re: Getting previous quarter value showing current quarter in dimension

sunny_talwar — Mon, 01 Aug 2016 14:15:33 GMT

This?

Expression:

Above(Sum({<Qtr>}Amount)) * Avg(1)

Re: Getting previous quarter value showing current quarter in dimension

Tue, 02 Aug 2016 05:53:52 GMT

This is not working, I am getting all zeros in real data when I am using the mentioned expression.

max({<QuarterYear={$(vPreviousQaurter)}>}[Cost]), this is showing both quarters Q4 and Q3.

QuarterYear = Q4'16

vPreviousQaurter= Q3'16

Re: Getting previous quarter value showing current quarter in dimension

sunny_talwar — Tue, 02 Aug 2016 10:09:39 GMT

Have you opened the application I have attached above? I am not sure what 0's you are talking about? Can you elaborate?

Re: Getting previous quarter value showing current quarter in dimension

Wed, 03 Aug 2016 07:59:31 GMT

Hi Sunny,

Above function is fetching correct results but in my case it is not working. As the there was blank in first row of my data the entire column is showing blank. I have used below expression and it worked fine. Thanks for your help. 🙂

=Aggr(Max({<Quarter={$(vPreviousQaurter)}>} Amount), RecordKey)

Regards,

Sai Krishna.