topic Set Analysis in QlikView

Set Analysis

Anonymous — Tue, 10 Jun 2014 06:12:33 GMT

Hi Qlicker

I want to write the same condition in set Analysis..

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

Thanks in Advance.....

Re: Set Analysis

jonathandienst — Tue, 10 Jun 2014 06:19:26 GMT

To select Not(isNull([PR No])), use the phrase [PR No] = {'*'}.

For the rest of the expression, see my answer to your previous post on a related query: http://community.qlik.com/thread/121390

HTH

Jonathan

Re: Set Analysis

MK_QSL — Tue, 10 Jun 2014 08:42:33 GMT

Count({<[%Indent status code] = {'K'}, [PR No] = {"=Len(Trim( [PR No]))<>0"}, [PO No] = {"=Len(Trim( [PO No]))=0"}>}DISTINCT [%Indent Line Number])

Re: Set Analysis

Anonymous — Tue, 10 Jun 2014 09:37:58 GMT

Hi Manish,

I used your condition but it showing the Error. Means i'm not getting the desired output...

Re: Set Analysis

tresB — Tue, 10 Jun 2014 09:42:51 GMT

Note: if you are using this expression in a chart with dimensions and expecting this expression to filter data row-wise, it would NOT. Set anaysis filters data once for an object. For that, IF is the solution.

Re: Set Analysis

Anonymous — Tue, 10 Jun 2014 10:04:46 GMT

Hi Tresesco,

Thanks for your suggestion, Mostly I'm preferred to IF condition only. But it was the requirement so I'm changing to Set analysis...

Re: Set Analysis

tresB — Tue, 10 Jun 2014 10:08:26 GMT

Set analysis should be preferred, because it is faster. But if the expression is meant for filtering data row-wise in the chart, you can't get that using set analysis. Hope it is clearer now.

Re: Set Analysis

Anonymous — Tue, 10 Jun 2014 10:09:41 GMT

OK Thank you .....

Re: Set Analysis

Tue, 10 Jun 2014 14:00:50 GMT

Hi Venkata, This will work when a selection is done.

=aggr(if(not IsNull(pr) and IsNull(po),Count({<indent = {'K'}>} total indentlinenumber)),pr,po)