topic Re: Using Not Equal condition in Set Analysis in QlikView

Using Not Equal condition in Set Analysis

tmumaw — Wed, 04 Jan 2012 14:47:24 GMT

Happy New Year everyone. I'm have a small issue when using not equal condition in set analysis. Here is the statement I am using and it's returning everything greater than 14 and I only want everything that is not equal to a 14. Thanks.

Thom

Sum({<FISYR=,FISPD=,WKNO=,WEDAT=,[Cancel Reason] = {"<>14"}>}[Subtotal1A] * -1)

Re: Using Not Equal condition in Set Analysis

Miguel_Angel_Baeyens — Wed, 04 Jan 2012 16:04:38 GMT

Hi Thomas,

Your expression seems to be fine. Anyway, you could try with something like

Sum({< FISYR=, FISPD=, WKNO=, WEDAT=, [Cancel Reason] -= {14} >} [Subtotal1A] * -1)

Using the -= operator to exclude that value for that field. You could also use E() function to exclude from [Cancel Reason] all values where [Cancel Reason] equals to 14, but the former is much simpler.

Hope that helps.

Miguel

Using Not Equal condition in Set Analysis

tmumaw — Thu, 05 Jan 2012 14:22:06 GMT

Thank you very much. It was exactly what I was looking for.

Thom

Re: Using Not Equal condition in Set Analysis

Anonymous — Thu, 31 Jan 2013 18:16:30 GMT

Hello! maybe you could help on my case. ( I'm a newbie in Qlikview) ... I have this pivotable that I want to excude an item during subtotal without suppressing null value...

Source DEC Jan Feb

A 0 0 20

B 15 20 30

C 40 50 60

I only want to add the values from DEC to Feb in Source B and C....But I want to keep the Source A data without suppresing value ...Thus would look like this

Source DEC Jan Feb

A 0 0 20

B 15 20 30

C 40 50 60

Total 55 70 90 exclude the value in A but data would still be visible

Pls. help...

Re: Using Not Equal condition in Set Analysis

Wed, 05 Feb 2014 07:33:52 GMT

Hi Miguel,

I tried the same way in my expression but still not working.

My expression is :

Count({<citizenship_StdPersonalInfo -= {'Singapore'}> +<isPR_StdPersonalInfo={0}>}DISTINCT(stdApplicationNo))

Can you suggest on it?

Thanks!!

-Yojas

Re: Using Not Equal condition in Set Analysis

tmumaw — Wed, 05 Feb 2014 14:58:04 GMT

Yojas,

Try this

Count({<citizenship_StdPersonalInfo -= {'Singapore'} + isPR_StdPersonalInfo={0}>}DISTINCT(stdApplicationNo))

Thom

Re: Using Not Equal condition in Set Analysis

Mon, 10 Feb 2014 07:46:54 GMT

Thanks for Reply Thom, my issue got solved..

-Yojas

Re: Using Not Equal condition in Set Analysis

tmumaw — Mon, 10 Feb 2014 12:46:26 GMT

Your welcome Yojas. Have a great day.