topic Re: QlikSense - current month data vs previous month in App Development

QlikSense - current month data vs previous month

Sun, 09 Aug 2015 20:25:16 GMT

Hello,

I am trying to create a sheet to display difference between previous month and current month data amounts.

So far I have tried to get amount difference for current month but no luck. Ideally I should get amount difference for every month.

My script is as follows (see attached project also):

sum({1<Date = {">=$(=monthstart(Today()))<=$(=monthend(Today()))"}>}Amount) - sum({1<Date = {">=$(=monthstart(AddMonths(Today(), -1)))<=$(=monthend(AddMonths(Today(), -1)))"}>}Amount)

but it gives me incorrect results. Any Ideas?

Re: QlikSense - current month data vs previous month

sinanozdemir — Sun, 09 Aug 2015 23:46:45 GMT

Hi Egor,

Can you check the new calculation sheet in the attached app? I created three text boxes, try to close the whole expression with brackets:

Hope this helps.

Thanks

Re: QlikSense - current month data vs previous month

Mon, 10 Aug 2015 11:04:08 GMT

Hello Sinan,

Yes it works, thank you very much!

Also how do I get amount difference not only for current month, but for every (e.g. selected) month?

Re: QlikSense - current month data vs previous month

sinanozdemir — Mon, 10 Aug 2015 14:45:53 GMT

Hi Egor,

Please see the below screenshots and attached qvf file:

As you can see from the above, based on user's selection "Current Month and Previous Month" numbers change.

Here is the expression for "Current - Previous":

In the attached qvf, please see the sheet name "New Calculation".

And if this answers your question, can you please mark this answer as the correct answer?

Thank you.

Re: QlikSense - current month data vs previous month

Mon, 10 Aug 2015 14:58:34 GMT

Thank you Sinan! That's all I need!

Re: QlikSense - current month data vs previous month

sinanozdemir — Mon, 10 Aug 2015 14:59:43 GMT

You are welcome.

Re: QlikSense - current month data vs previous month

nituverma097 — Wed, 24 Jun 2020 14:23:52 GMT

Hi, I am also stuck here. It will give the correct month but not give any values, it gives 0 value. Please find the screenshot.