topic Re: Set Analysis Previous Date Range in QlikView

Set Analysis Previous Date Range

phongnnguyen — Wed, 30 May 2018 06:23:04 GMT

Hi Qlik Senser,

I'm fresh in Qlik, I have a problem when I set Analysis Date range for Previous.I want to show sum Revenue of the month before the currently month. For instance:

I choose in filter chart from 2018-Apr-01 to 2018-Apr-30 and in the KPI chart will show the revenue from 2018-Mar-01 to 2018-Mar-31

This is my code: Sum({<TradeDate={">=$(=MonthStart(AddMonths(max(TradeDate),-1))<=$(=MonthEnd(AddMonths(max(TradeDate),-1))"}>}if( K=0 and Interest>0,Interest))

Thanks for you help.

Re: Set Analysis Previous Date Range

sunny_talwar — Wed, 30 May 2018 15:45:01 GMT

May be try this

Sum({<TradeDate = {">=$(=MonthStart(Max(TradeDate), -1))<$(=MonthStart(Max(TradeDate)))"}, K = {0}, Interest = {">0"}>} Interest)

Re: Set Analysis Previous Date Range

phongnnguyen — Thu, 31 May 2018 01:57:49 GMT

Thanks for your reply, but maybe this has problem when I use MonthStart and Month End

Re: Set Analysis Previous Date Range

Anonymous — Thu, 31 May 2018 08:00:06 GMT

Hye,

why not The As-Of Table as u told me Sunny ?

Re: Set Analysis Previous Date Range

sunny_talwar — Thu, 31 May 2018 08:59:01 GMT

Well you can use AsOfTable, but not every issue needs it... in this case, it doesn't seem the OP is comparing periods on a single chart where period is the dimension or looking to accumulate the value of the period where period is the dimension. Those are the two cases where I can think it to be most useful, but it is not to say that it can't be used.

Re: Set Analysis Previous Date Range

sunny_talwar — Thu, 31 May 2018 15:33:29 GMT

Are you able to share a sample to show the issue?