topic Re: Select and avoid nulls at the same time in QlikView

Select and avoid nulls at the same time

Tue, 22 Dec 2015 14:30:46 GMT

Hi all,

I have a database where the nulls values are set as 99.

When I calculate the average of the satisfaction for example I use this way to avoid nulls values:

Avg ({$-< [Satisfaction]={"99"}>}[Satisfaction])

The problem is when I tried to select the satisfaction of several logistic values (for example YES or NOT use Whatsapp)

I can do this with the following formula:

Avg ({<[WhatsApp Usage]={"YES"}>}[Satisfaccion])

My problem is how can I do this to the same time? This is, obtain the satisfacction of Whatsapp users but without taking into account the Satisfaction null values that are increasing incorretly the average.

Thanks in advance

Regards

Javi

Re: Select and avoid nulls at the same time

roger_stone — Tue, 22 Dec 2015 14:39:52 GMT

Have you tried this:

Avg ({$-< [Satisfaction]={"99"},[WhatsApp Usage]={"YES"}>}[Satisfaction])

Re: Select and avoid nulls at the same time

thakkarrahul01 — Tue, 22 Dec 2015 14:40:25 GMT

You can use on expression with both the conditions like :

Avg ({<[WhatsApp Usage]={"YES"},[Satisfaction]-={"99"}>}[Satisfaccion])

Re: Select and avoid nulls at the same time

roger_stone — Tue, 22 Dec 2015 14:41:22 GMT

Or this

Avg ({$< [Satisfaction]-={"99"},[WhatsApp Usage]={"YES"}>}[Satisfaction])

Re: Select and avoid nulls at the same time

Tue, 22 Dec 2015 15:26:49 GMT

This formula is giving me the opposite avoiding 99 and whatsapp