Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Finding "Total" rows without using inter chart function

Hi guys,

I am using this expression to avoid "Total rows" from rendering any Date.

If(RowNo() <>0  and not IsNull(RowNow())), TxnDate)..

I want to know if there is any way to find total rows without using RowNo() or dimensionality() in a pivot and straight chart.

-Saurabh

2 Replies
sujeetsingh
Master III
Master III

=count(TOTAL FieldName)

Not applicable
Author

should i use

= count(TOTAL TxnDate)

and what is expected output of this function when it finds a TOTAL row...