topic Re: Show previous month data in QlikView

Show previous month data

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

Hi all

In pivot table how to show the previous month data without any filter selections.

I have a date and month fields.

Thanks

Deepak

Re: Show previous month data

sunny_talwar — Mon, 14 Nov 2016 16:38:58 GMT

Do you have date or month as dimensions in your pivot table?

Re: Show previous month data

deepakkrish — Mon, 14 Nov 2016 16:41:31 GMT

In dimensions field i don't have a month and date fields.

Re: Show previous month data

sunny_talwar — Mon, 14 Nov 2016 16:43:35 GMT

See if this links help:

The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync‌

UPDATE: Adding a snippet from the above link

Re: Show previous month data

deepakkrish — Mon, 14 Nov 2016 16:55:59 GMT

Is there another way to achieve this requirement?. Because i am not familiar with set analysis, otherwise can u explain

briefly how to achieve this?

Thanks

Re: Show previous month data

sunny_talwar — Mon, 14 Nov 2016 16:57:58 GMT

With the amount of information you have provided, I am not sure if there is another simpler way to do this, but you can look into here: The As-Of Table.

Also, if you are able to provide a sample, may be one of us can show you how this can be done in your sample file.

Best,

Sunny

Re: Show previous month data

johnw — Tue, 15 Nov 2016 00:18:02 GMT

I recommend learning about set analysis, then. It's a very useful tool, and probably simpler than implementing an AsOf table, even if AsOf tables are my go to solution for many date-related problems. I'm not thinking of a third way, but also won't be surprised if someone posts one.

Re: Show previous month data

Anonymous — Tue, 15 Nov 2016 04:23:04 GMT

Hi ,

Use set analysis , its simple and very useful .

Re: Show previous month data

deepakkrish — Wed, 16 Nov 2016 18:40:14 GMT

Thanks for your suggestion. it's working ,simply superb..

Re: Show previous month data

sunny_talwar — Wed, 16 Nov 2016 18:42:24 GMT

I am glad you put in effort to finally able to resolve your issue. This will def. go long way for you to learn set analysis if you are not used to using it much.

Best,

Sunny

Re: Show previous month data

Eugene007 — Thu, 04 Mar 2021 10:17:14 GMT

Hi there, I am also trying to show previous months data, here is my current expression, what do I need to apply to change the results?

SUM({<DateKey = {">=$(=Min({<FYP = {"$(=$(vCurrFYP))"}>} DateKey))<=$(=NUM(Date(vToday)))"}, FinancialCode =- {9999}, ProfitCentreCode = {2}, Date= >} RoomsSold)