topic Re: Pivot Table Previous Month and current Month in QlikView

Pivot Table Current and Previous Using above

Anonymous — Mon, 12 Oct 2015 04:51:10 GMT

Hi friends,

Here in the pivot table at Diff % prev Month Difference lane , i want to display first row result.

Please Help,I have attached app also .

Thanks in advance,

Bunny.

Re: Pivot Table Previous Month and current Month

jonathandienst — Mon, 12 Oct 2015 05:28:03 GMT

Text - refers to diff vs previous month

Picture - refers to expression (Supply - Consumption) / Supply

Which is the correct one?

Re: Pivot Table Previous Month and current Month

Anonymous — Mon, 12 Oct 2015 05:41:50 GMT

Hi,

Picture is correct i want to display the first line i.e Rowno()=1 . You can have a view in application attached.

Re: Pivot Table Previous Month and current Month

jonathandienst — Mon, 12 Oct 2015 05:48:39 GMT

The expression in that column uses above(). As this is the first row, the above() does not exist and therefore returns null. I do not understand what you are trying to do in that expression, but generally month-on-month comparisons do not have a % change for the first month.

Re: Pivot Table Previous Month and current Month

settu_periasamy — Mon, 12 Oct 2015 05:54:33 GMT

Hi Bunny,

may be you can check the attachment .. (bit ugly-but i think it will work).

Re: Pivot Table Previous Month and current Month

Anonymous — Mon, 12 Oct 2015 05:58:23 GMT

Hi Jonathan ,

I want to display first row as for the formula ((Supply-consumption)/Supply )and remaining rows should be Difference value from previous month.

Because i have query, when i m using this expression it is working on my local Desktop but on my Test environment it is displaying all the Yearmonth from starting to end .

Many thanks for your response,

Bunny

Re: Pivot Table Previous Month and current Month

jonathandienst — Mon, 12 Oct 2015 06:07:44 GMT

Then you need this construct

If(RowNo(TOTAL) = 1, .... expression for first row ...., .... expression for other rows)

Re: Pivot Table Previous Month and current Month

Anonymous — Mon, 12 Oct 2015 06:19:32 GMT

Hi settu ,

Thank you its working ,

I m having a query .

In my local Machine its looking fine but when i deploy on the test instance it is showing all the YearMonth from starting to end .

when i disable this particular above condition used expression all works fine there .

Re: Pivot Table Previous Month and current Month

Anonymous — Mon, 12 Oct 2015 07:06:10 GMT

Dear Jonathan ,

Thanks for your help i acquired the desired result but when i deploying on test its displaying all yearMonth from starting to end with out data.

When using that particular expression .

But it works fine on my local .Please Help .

Thanks in advance .

Bunny.

Re: Pivot Table Previous Month and current Month

settu_periasamy — Mon, 12 Oct 2015 07:34:46 GMT

Hi Bunny,

Did you try to use the Label name instead of the entire expression.. like

Diff % Prev Month Difference

if(IsNull([Diff %]-Above([Diff %])),[Diff %],[Diff %]-Above([Diff %]))

Re: Pivot Table Previous Month and current Month

Anonymous — Mon, 12 Oct 2015 08:10:10 GMT

Hi settu ,

I tried its working on local but not on the test instance .

thanks for your response .please help.

bunny