Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to count the occurences of 'OTHERS' ONLY per field in a pivot table?

Ex.

Dimension:       V1

One of the values is 'OTHERS'

HOW do  I count the occurrences of  'OTHERs'  ONLY in a pivot table?

I want to do this  for other dimensions like V2, V3, etc.,

Sample output:

Dimension          Count(Others)       Percent

V1                           20                         60%

V2                           130                       30%

V3                           12                         45%

Thanks heaps in advance.

5 Replies
MK_QSL
MVP
MVP

Count ({<Dimension = {'V2','V3'}>}Others)

Not applicable
Author

That's helpful. Gave me an idea. I used the below formula instead.

Count({<$(=minstring($Field)) = {'OTHERS'}>}$(=minstring($Field)))

BUT, How do I get the percent?

MK_QSL
MVP
MVP

What is the % in your case... i.e. what is the formula you have used?

Not applicable
Author

That's a follow up question.

MK_QSL
MVP
MVP

I mean what is the logic behind getting percentage...

i.e

SUM(Sales)/SUM(Total Sales)

or

COUNT([Invoice Number])/ COUNT(TOTAL [Invoice Number])

In your case may be...

Count ({<Dimension = {'V2','V3'}>}Others)/Count (TOTAL {<Dimension = {'V2','V3'}>}Others)

or

Count ({<Dimension = {'V2','V3'}>}Others)/Count (TOTAL Others)