Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
evgeniystuchalk
Not applicable

Stucked with total in pivot table

Hello! I need count total for each column of this table:

12MjexXIMkke3A.jpg

Problem is: when i'm use total, it counts all companies at all.

ceae3edfca.jpg

I need totals only for rows. My expression is:

Count({$<[Success Deals]={'>=1'}>} total distinct [ID company])

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Stucked with total in pivot table

Add the month-year field you use a dimension in your pivot table in < > tags after the total keyword: Count({$<[Success Deals]={'>=1'}>} total <MonthYear> distinct [ID company])


talk is cheap, supply exceeds demand
1 Reply
Gysbert_Wassenaar
Not applicable

Re: Stucked with total in pivot table

Add the month-year field you use a dimension in your pivot table in < > tags after the total keyword: Count({$<[Success Deals]={'>=1'}>} total <MonthYear> distinct [ID company])


talk is cheap, supply exceeds demand