topic Re: current Month vs Previous Month in QlikView

current Month vs Previous Month

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I've attached an app. See Sheet 1

In table Current vs Previous, I want to show the Sum of Values for the current month in one column and the Sum of Value for previous Month in another column.

Showing only the month in column 2 and 3, I can show current month and its previous month, but when it comes to the Sum of values, I can't show the correct values.

Probably something wrong in my set analysis expression

Can you please help me?

This is what I want to achieve:

Thanks in advance.

Sílvia

Re: current Month vs Previous Month

vinieme12 — Fri, 10 Feb 2017 12:28:18 GMT

Try

Dimension:

MonthYear

Expressions:

Current Month

Sum(Value)

PreviousMonth

Above(Sum(Value))

Re: current Month vs Previous Month

Anil_Babu_Samineni — Fri, 10 Feb 2017 12:34:32 GMT

I've used for Max MonthYear

Sum({<MonthYear = {"$(=Max(MonthYear))"}>}Value)

And Previous MonthYear i used this

Sum({<MonthYear = {"$(=Date(Max(MonthYear)-1,'MMM-YYYY'))"}>}Value)

Image looks like this, Is this you are expecting to see

Re: current Month vs Previous Month

Anonymous — Fri, 10 Feb 2017 12:35:44 GMT

Thanks Vineeth, it works

By the way, If I add a column that corresponds to the difference between the two values:

CurrentMonth - PreviousMonth: Sum(Value) - Above(Sum(Value))

If I create a line char with only this new calcultaion it works too.

This Above() function, can it be used in all types of charts?

Regards,

Sílvia

Re: current Month vs Previous Month

vinieme12 — Fri, 10 Feb 2017 12:40:43 GMT

Yes, you can but it can be tricky at times to make it work.

Here is another application of above() with Rangesum(), for accumulation of values

Accumulative Sums

Re: current Month vs Previous Month

Anonymous — Fri, 10 Feb 2017 12:47:28 GMT

Ok.

Another question:

I want that regardless the selection I made in MonthYear, it always shows all values.

I mean keep the table static, regardless all dimensions that are associated with dates.

I only need to add that to the set analysis ?

Like MonthYear=, Year=, Date=... Like this ?.

Re: current Month vs Previous Month

vinieme12 — Fri, 10 Feb 2017 13:01:46 GMT

correct, should work