topic Re: How to show previous month data in current month? in QlikView

How to show previous month data in current month?

Anonymous — Thu, 05 Jan 2017 03:34:11 GMT

Hi All,

With month as dimension, I want to show previous month data in each month. If I use variable, it shows in two lines. I need to see in one line. Please advice.

Regards,

Ruchi

Message was edited by: Ruchi Bagaria

Re: How to show previous month data in current month?

punitpopli — Thu, 05 Jan 2017 04:35:03 GMT

Can you please share an example what you are trying to achieve and would be great if you can add a sample QVW file

Re: How to show previous month data in current month?

Anonymous — Thu, 05 Jan 2017 04:58:52 GMT

Hi Punit,

I have attached a sample app with sample source data. And thanks for the response.

Regards,

Ruchi

Re: How to show previous month data in current month?

punitpopli — Thu, 05 Jan 2017 06:35:22 GMT

two line, do you mean in two different columns?

and you need it to have both Previous month stock and Current month stock in a single column?

Re: How to show previous month data in current month?

Anil_Babu_Samineni — Thu, 05 Jan 2017 06:42:56 GMT

May be use this for Previous Month for your Pivot Object

=sum({<MonthYear = {"$(=Date(Max(MonthYear-1),'MMM-YYYY'))"}>}[Total Stock])

Or By using Variable you may try this

=sum({<MonthYear = {"$(=vPrevMthNo)"} >}[Total Stock])

Re: How to show previous month data in current month?

Anonymous — Thu, 05 Jan 2017 07:13:26 GMT

Hi Anil,

I had tried both. The problem is, the sata comes in two rows. I want it be in a single row.

Regards,

Ruchi

Re: How to show previous month data in current month?

Anonymous — Thu, 05 Jan 2017 07:25:30 GMT

Hi Friends,

I could solve it. I just had to take the Price from Dimension as put it as a measure and it worked. Hence, closing the discussion. Thanks for your responses.

Regards,

Ruchi

Re: How to show previous month data in current month?

punitpopli — Thu, 05 Jan 2017 07:32:38 GMT

try using aggr function like below :

=aggr(sum({<MonthYear={'$(vPrevMthNo)'}>}[Total Stock]),[Planning Article])

=Aggr( sum([Total Stock]),[Planning Article])

Re: How to show previous month data in current month?

punitpopli — Thu, 05 Jan 2017 09:58:48 GMT

Hi ruchibagaria‌

Please mark response from above as helpful/correct answer to closed the thread

Thanks

Re: How to show previous month data in current month?

Anil_Babu_Samineni — Thu, 05 Jan 2017 10:18:07 GMT

What do you meant by single row here, can you describe more your intend to look

I got like below, What was the expect from here

Re: How to show previous month data in current month?

Anonymous — Fri, 06 Jan 2017 09:47:09 GMT

Hi Punit,

The solution I tried is messing up my other fields. So, I have kept it open now. I tried your option too. It does work on this sample data but is not constant for all selections in my data model. Let me provide a better example.

Meanwhile please let me know if you can think of any alternative for this scenario.

Regards,

Ruchi Bagaria