Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ariel_klien
Specialist
Specialist

Total Count in Pivot Table

Hello all,

Please help me with this issue...

I have a pivot table with 2 dimensions and 2 expressions. (see pic.)

aa.png

I want that  in the total column will show the total of the Name. as you can see in the pic that the expression is working only in one raw in the other one its write a '0' (circle by red square).

the Total expression is sum(aggr(Count(Log),Name))

the correct view should be like this:

aaa.png

any idea?

Ariel

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try count(total <Name> Log)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Try count(total <Name> Log)


talk is cheap, supply exceeds demand
ariel_klien
Specialist
Specialist
Author

Working!!

Thanks