topic Re: How to indicate last row in pivot table chart type? in QlikView

How to indicate last row in pivot table chart type?

Wed, 21 May 2014 12:52:56 GMT

Hi guys,

I need of a quick suggestion on this one. I think this should be easy but since the lack of knowledge I really don't know how to do this.

Say the following pivot table chart type displays all the data that I wanted

The rows in this table, is of course, dynamic. What I want is to be able to highlight/or identify which is the last row in this table.

I was thinking to add an expression in which if(rowno(total)=max(rowno(total),'LAST ROW') but QlikView keep on crashing as soon as I click apply.

Is there any workaround to this problem?

Thank you so much for your time attending to my question guys.

Re: How to indicate last row in pivot table chart type?

ashfaq_haseeb — Wed, 21 May 2014 12:55:07 GMT

Hi,

Go to presentation tab and select show partial sum

Regards

ASHFAQ

Re: How to indicate last row in pivot table chart type?

Wed, 21 May 2014 13:02:12 GMT

Hello,

Thank you for your reply, but what I am trying to achieve is something like this

Another column to show 'Last' on the last row of the displayed result in the pivot table chart type.

Was wondering if this is possible because last time I add a column there with the expression if(rowno(total)=max(rowno(total),'LAST ROW'), QlikView just crashed after I click Apply.

Thank your for your kind attention

Re: How to indicate last row in pivot table chart type?

Gysbert_Wassenaar — Wed, 21 May 2014 13:07:15 GMT

Maybe something like this: if(rank(total RowNo(total)) = 1, 'Last')

Re: How to indicate last row in pivot table chart type?

Fri, 23 May 2014 07:11:48 GMT

Hello Gysbert,

Thank you for your time for answering my question.

That definitely was the correct expression but it was silly of me that I failed to notice this particular condition; while it correctly displayed the last row in the pivot table for a selected country, but when you select multiple country it correctly displayed the last row of the pivot table.

But how do I tweak the expression so that it will display at the last row of each country selected and displayed in the pivot table? As pictured below

Again thank you very much for your kind attention. Hope to hear from you. Have a nice day