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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to count # of values which exceed 1000?

I have a pivot chart which has the following:

                      1             2             3    …

Shehan     975       1050     1102

James       950       1175     1101

Stewart    1105       980       985

Emmett   1000     1005       975

I need a fourth column where it looks and counts the number of values which exceed 1000.

                      1             2             3    …    overages

Shehan       975       1050     1102              1

James         950       1175     1101              2

Stewart      1105       980       985              1

Emmett     1000     1005       975              0

1 Solution

Accepted Solutions
its_anandrjs
Champion III
Champion III

Hi,

See the attached sample file i think you use like this see the fourth expression overages in the pivot table on the Solution sheet

See the attached sample.

Regards,

Anand

View solution in original post

1 Reply
its_anandrjs
Champion III
Champion III

Hi,

See the attached sample file i think you use like this see the fourth expression overages in the pivot table on the Solution sheet

See the attached sample.

Regards,

Anand