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

Exclude count and sum values

I got three expressions in my chart

if (Count (X) > 1, Count (X), '-') 

if (Sum (XX) > 1, Sum (XX),'-')

if (sum (XXX)> 31, sum (XXX),'-')

I want to show only rows that qualify all the above expressions?

now i have for example:

X          XX          XXX

-          3               -

-          -                -

2          3              32

I want

X          XX          XXX

2          3               32

Daniel

2 Replies
Not applicable
Author

Can you share sample data?

jerem1234
Specialist II
Specialist II

You can try this for your 3 expressions:

if (Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31, Count (X))

if (Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31, Sum (XX))

if (Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31, Sum (XXX))


or you can try a calculated dimension like:


aggr(only({<YourField = {'=Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31'}>}YourField), YourField)


then with expressions:


count(X)

sum(XX)

sum(XXX)


Hope this helps!