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

To calculate occurrences of counts

Hi,

I need to calculate the occurrences of all counts.

For example: -

I want to show all the counts that are 1 occurred four times and the count 3 occurred once.

How do i show in pivot chart expression ?

4 Replies
Anil_Babu_Samineni

May be you need Aggregation to count them. Would you describe more which illustrates the issue

Count({<OccuredDim = {'1'}>}Measure) //Here, This will all Measure values with only One Point with occured

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

how do i incorporate above formula into this count(key1) ?

Anil_Babu_Samineni

I didn't understand 100% fully. You may describe more

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

I apply this =count(Key1)and only get count on respective dates. How do i cal calculate the occurrences for ex- 1 occured four times and 3 occured 1 times