How to indicate last row in pivot table chart type?

[#1]

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.

[ashfaq_haseeb]

Hi,

Go to presentation tab and select show partial sum

Regards

ASHFAQ

[#3]

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

[Gysbert_Wassenaar · Accepted solution]

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

[#5]

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