topic Re: Set Analysis in QlikView

Set Analysis

Anonymous — Tue, 10 Jun 2014 05:47:23 GMT

Hi Qlikers,

I want to Write the same condition in Set analysis

Count(distinct(if([%Indent status code]='K' and IsNull([PR No]),[%Indent Line Number])))

Re: Set Analysis

preminqlik — Tue, 10 Jun 2014 05:50:31 GMT

try with this

Count(distinct {<[%Indent status code]={'K' } ,[%Indent Line Number]={'=IsNull([PR No]'}>}[%Indent Line Number])

Re: Set Analysis

er_mohit — Tue, 10 Jun 2014 05:52:06 GMT

try this

count(distinct {<[%Indent status code]={'K'}>*<[PR No]={' '}>}[%Indent Line Number])

or this way

count(distinct {<[%Indent status code]={'K'},[PR No]={' '}>}[%Indent Line Number])

Re: Set Analysis

preminqlik — Tue, 10 Jun 2014 05:52:19 GMT

try also

Count(distinct {<[%Indent status code]={'K' } ,[PR No]={"null()"}}>}[%Indent Line Number])

Re: Set Analysis

Anonymous — Tue, 10 Jun 2014 05:59:35 GMT

Hi Prem,

I;m tried your Condition but it is not working...

Re: Set Analysis

Anonymous — Tue, 10 Jun 2014 06:01:28 GMT

Hi Mohit,

I'm tried your Condition but it is not working...

Re: Set Analysis

MayilVahanan — Tue, 10 Jun 2014 06:04:11 GMT

Try like this

Count(distinct {<[%Indent status code]={'K' } ,[PR No]-={"*"}>}[%Indent Line Number])

Re: Set Analysis

Anonymous — Tue, 10 Jun 2014 06:10:25 GMT

Hi Mayil,

I'm tried your Condition but it is not working...

Re: Set Analysis

jonathandienst — Tue, 10 Jun 2014 06:11:27 GMT

Set analysis is equivalent to automating selections made from the front end. When selecting items, you cannot select null values. In the same way, set analysis cannot select null objects. You can either do this:

Count({<[%Indent status code]={'K' }>} distinct If(IsNull(PR_No), [%Indent Line Number]))

or enter the phrase

NullAsValue PR_No;

to your load script before the LOAD statement that loads the PR_No values. Then use:

Count({<[%Indent status code]={'K'},[PR No]={''}>} distinct [%Indent Line Number])

HTH

Jonathan

Re: Set Analysis

preminqlik — Tue, 10 Jun 2014 06:34:05 GMT

then try this

Count(distinct {<[%Indent status code]={'K' }*{'=IsNull([PR No]'}>}[%Indent Line Number])