topic Re: Chart with months as dimension: Current month's data the same as last's in QlikView

Chart with months as dimension: Current month's data the same as last's

Tue, 23 Dec 2014 10:35:18 GMT

Hi,

I have a chart:

It sums data by month.

I want the current month (12), instead of being the actual data, to be the same as the month before it (11).

How can it be done?

The attached qvw has the relevant chart.

Thanks!

Re: Chart with months as dimension: Current month's data the same as last's

mdmukramali — Tue, 23 Dec 2014 10:44:03 GMT

Dear ,

Kindly find the attached workaround for your issue.

Re: Chart with months as dimension: Current month's data the same as last's

Anonymous — Tue, 23 Dec 2014 10:44:10 GMT

So you are after what is labelled Month 12 to show value for Month 11.

For what is labelled Month 11 do you wish to show Month 11 value or that of Month 10 ?

Re: Chart with months as dimension: Current month's data the same as last's

Tue, 23 Dec 2014 10:49:35 GMT

Please find the attached Document

Re: Chart with months as dimension: Current month's data the same as last's

tresB — Tue, 23 Dec 2014 10:51:55 GMT

Among many options, one:

If(Month=vMaxMonth, sum(total {<Month={"$(vPreMaxMonth)"}>}Data), sum(Data))

PFA

Re: Chart with months as dimension: Current month's data the same as last's

jyothish8807 — Tue, 23 Dec 2014 11:09:09 GMT

Hi Tresesco

I did the same before, but in my case its giving 148 to all the months can you tell me why?

I used:

if(Month=max(Month), sum(Total{<Month={'$(=Max(Month)-1)'}>}Data), sum(Data))

In my case all the months are getting same value, how?

Regards

Re: Chart with months as dimension: Current month's data the same as last's

tresB — Tue, 23 Dec 2014 11:19:04 GMT

Because of 'Month=Max(Month)' section of the formula. While your dimension is Month, Max(Month) would be always the same month(that is there in the row) as in the rows. Hence, the Month=Max(Month) comes always true for all rows.

You could try:

if(Month=max(Total Month), sum(Total{<Month={'$(=Max(Month)-1)'}>}Data), sum(Data))

Hope that helps.

Re: Chart with months as dimension: Current month's data the same as last's

jyothish8807 — Tue, 23 Dec 2014 11:27:43 GMT

Got it , thanks a lot Tresesco

Regards