topic Re: Load a sub-set of data in QlikView

Load a sub-set of data

Tue, 09 Jun 2015 12:34:37 GMT

Hi, I'm a newby whjo needs some help!.

I'm loading a table of risk data, but I want to load an aditional sub-set of it as well.

So as well as the 'Risk Owner' field, I want to develop a seperate field of 'Active Risk Owner', only where the 'Risk Status' is 'Active'.

I've been trying to figure out how to do this in the load script using IF and THEN statements, to no sucesses.

If [Status] ='Active' Then [Risk Owner] as [Active Risk Owner],

Am I close??

Any suggestions??

Colin-Albert — Tue, 09 Jun 2015 12:38:44 GMT

You can use If within the load statement.

RiskData:

Load

Status,

[Risk Owner],

If([Status] ='Active' , [Risk Owner]) as [Active Risk Owner],

....

Tue, 09 Jun 2015 12:41:25 GMT

Try this,

if([Status] ='Active',[Risk Owner]) as [Active Risk Owner]

Tue, 09 Jun 2015 12:51:43 GMT

Thanks Colin - i wasn't that far off after all!

really appreciate your help

Tue, 09 Jun 2015 12:52:33 GMT

Thanks for that - it works now!