Set Analysis

[Anonymous]

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])))

[preminqlik · Accepted solution]

try with this

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

[er_mohit]

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])

[preminqlik]

try also

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

[Anonymous]

Hi Prem,

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

[Anonymous]

Hi Mohit,

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

[MayilVahanan]

Hi

Try like this

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

[Anonymous]

Hi Mayil,

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

[jonathandienst]

Hi

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

[preminqlik]

then try this

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