Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count of Dimension

Hi,

How we can count the Dimension Values And Display In Pivote Table

Kindly Have a Look on Attachment

1 Solution

Accepted Solutions
sunny_talwar

3 Replies
sunny_talwar

This?

Capture.PNG

swuehl
MVP
MVP

Dimension: Country

1. expression: =Count(Country)

2. expression: =Sum(Sales)

Sales figure differs from what you've posted.

edit:

1. expression: Count(Distinct State)

would probably be more correct

robert_mika
Master III
Master III

Like this?