Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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