topic Re: Flags in QlikView

Flags

rathnam_qv — Wed, 28 Aug 2013 13:45:21 GMT

Hi All

i have nearly 1300 Accounts ...

i want to create 1 flag for 21 Accounts...and another flag for remaining Accounts..

So, How to create That Flags...

Can any one help me

Thanks in Advance!!!

Smiley

Re: Flags

rajeshvaswani77 — Wed, 28 Aug 2013 14:20:42 GMT

Create a column using if condition, if the conditin is true you have one value( for 21 accounts) and in else you will have another value. Call this new column name as flag or any appropriate name.

thanks,

Rajesh Vaswani

Re: Flags

rathnam_qv — Wed, 28 Aug 2013 16:04:36 GMT

Hi,

can u please send me the script

Re: Flags

MayilVahanan — Wed, 28 Aug 2013 16:09:16 GMT

try like this

If(Accounts <= 21, 1, 0) as Flag

If its not in order, then try with match() function , like

if(match(Account,1,2,34,5,67,889,45,46), 1, 0) as Flag

hope that helps

Re: Flags

rathnam_qv — Thu, 29 Aug 2013 01:54:47 GMT

Hi,

i know the 21 account numbers...remaining i don't know...

then

Re: Flags

kalyandg — Thu, 29 Aug 2013 03:38:19 GMT

hi rathnam,

for 21 accounts(which do u know)

try as the above reply by mayilvahanam

for the next 21,

try as

if(Accounts<>21, 1,0) as Flag2

kindly reply

Thanks,

Kalyan

Re: Flags

jagan — Thu, 29 Aug 2013 04:00:56 GMT

Hi,

Try like this

LOAD

if(match(Account,1,2,3, .....................your 21 account), 1, 0) as Flag,

if(not match(Account,1,2,3, .....................your 21 account), 1, 0) as RemainingAccountsFlag

FROM Datasource;

Regards,

Jagan.

Re: Flags

Thu, 29 Aug 2013 05:42:12 GMT

try according to this condition

If(Accounts <= 21, 1) as Flag1

If(Accounts > 21, 0) as Flag2

***************************************

or add rowno() as key

then try

if(key<=21,1) as flag1,

if(key>21,0) as flag2

Re: Flags

CELAMBARASAN — Thu, 29 Aug 2013 06:13:00 GMT

Hi,

If(Match(Accountnumbers, 1,2,3,4,5....,21), 1, 0) AS Flag

Here Flag =1 has account numbers you know. Flag =0 has remaining account numbers