topic Re: Exclude count and sum values in QlikView

Exclude count and sum values

Thu, 14 Aug 2014 14:29:21 GMT

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

Tue, 04 Nov 2014 17:33:40 GMT

Can you share sample data?

jerem1234 — Tue, 04 Nov 2014 17:50:55 GMT

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!