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

Pivot Total Issue

Hi

I have below expression in pivot table and Date as dimension

 

=if(TAT>=0 and TAT<=3, TextCount(DocNo)) 

Total at the bottom not showing any value

Seleted show partial sum for Date

Thanks in advance

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi,

Not sure you try this yet

TextCount(if(TAT>=0 and TAT<=3, DocNo))

Regards,

Sokkorn

View solution in original post

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try this.

     Sum(Aggr(if(TAT>=0 and TAT<=3, TextCount(DocNo)),DATE))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

A little explanation. 

Total make sense only for aggregation.  For example, if your expression is

Amount

there can be no total.  To get total, you have to use

sum(Amount)

KS recommends to use sum() as your expression, so the total is clearly defined.

Regards,

Michael

Not applicable
Author

In this case if not executing correctly.

Count is not coming correct for some date

TAT is based on DocNo

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Yes.

     To get the total's, your expression should have aggregation functions like Sum,Avg,.. and so on.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Sokkorn
Master
Master

Hi,

Not sure you try this yet

TextCount(if(TAT>=0 and TAT<=3, DocNo))

Regards,

Sokkorn

Not applicable
Author

Worked

Thanks alot