topic Creating Flag? in QlikView

Creating Flag?

khadeer — Thu, 13 Sep 2012 16:19:12 GMT

Hi,

I have one coloumn with batch codes like AB1000, AB2000, CD3000,CE4000, AB5000 like this i have so many fields in that BATCH dimension. Now i have to divide those fields as 2 different dimensions.

The batch code which starting with AB is come into one group remainining into other group......

How i can do in backend.

Regards,

Khadeer

Re: Creating Flag?

MayilVahanan — Thu, 13 Sep 2012 16:28:43 GMT

Try like this,

Load *, if(wildmatch(BatchCode,'AB*',BatchCode) as SplitBatch from table;

Hope it helps

Re: Creating Flag?

Thu, 13 Sep 2012 16:41:37 GMT

this...

If (Left(Group,2) = 'AB','AB Group', 'Other') as Category