topic Re: isnull and not isnull in Set Analysis in QlikView

isnull and not isnull in Set Analysis

Fri, 07 Jun 2013 13:42:52 GMT

Hi guys,

I don't have any ideas how to write isnull and not is null in expression using Set Analsyis. In attached example, I have represented how it looks using if function, but I have to write it using set analysis. The task is to calculate amount fot that records where FirstValue hasn't value but SecondValue has it without anything changing in the script.

Thanks for help.

Re: isnull and not isnull in Set Analysis

swuehl — Fri, 07 Jun 2013 13:49:18 GMT

Try

=sum({$<FirstValue = {'*'} > - < SecondValue = {'*'}>} Amount)

Re: isnull and not isnull in Set Analysis

Fri, 07 Jun 2013 13:54:45 GMT

Hi,

Try,

Rebeca

Re: isnull and not isnull in Set Analysis

Mon, 10 Jun 2013 10:17:30 GMT

Thanks, in that case it works, but I have one misundertanding. For example, If I relate this table1 with table2 which contains discription of that 'Dim' field and use insteed of it then it shows strange result (0 values in 'With Set Analysis' column). Please see new attached file.

Re: isnull and not isnull in Set Analysis

swuehl — Mon, 10 Jun 2013 10:31:29 GMT

Yes, looks kind of strange.

Alternatively, you can create a RecID field in your script and do something like:

sum({$<RecID = p({<FirstValue = {'*'} >}) - p({<SecondValue = {'*'}>}) >} Counter)

Re: isnull and not isnull in Set Analysis

Mon, 10 Jun 2013 10:39:18 GMT

But unfortunately I don't have opportunity change anything in the app. script.