topic Simple Set analysis hellp in QlikView

Simple Set analysis hellp

Tue, 29 Oct 2013 18:35:53 GMT

I have a spreadsheet two two columns

Division and Helps as a column header.

So in the helps column there could be other divisions or Orgs, Sucjh as

Division Helps

D1 D2

D3 D1

D1 Org1

I want to have a straight table that shows D1 what other divisions D1 helps without the Org1, so basically where Helps=another division name

Re: Simple Set analysis hellp

andrewpettit — Tue, 29 Oct 2013 18:50:21 GMT

I personally would pre-calculate a flag on the backend that says if they are equal or not and then write my Set Analysis to select either a 1 or 0 in my flag field.

Re: Simple Set analysis hellp

preminqlik — Tue, 29 Oct 2013 19:12:02 GMT

try this !

in UI : if(Helps<>'Org*',Helps)

in script:

while loading u can keeep flag as :

load Division,

Helps,

if(Helps<>'Org*',1,0) as helps_flag

FROM..............

IN UI CALL AS ; IF(helps_flag=0,Helps)

Re: Simple Set analysis hellp

israrkhan — Tue, 29 Oct 2013 19:37:10 GMT

you can also try like this,

if( Helps = 'D*',Helps)