How to use Flag in qlikview Script?

[dolly777]

Hi All,

I have two fields like Recommended and non-Recommended . I need to use flag Y for Recommended and flag N for non-Recommended field and  also merge these two fields into one field with respective flag . Could you please give some idea how to write script in qlikview ?

Thanks!

[arvind_patil · Accepted solution]

HI Nirmala,

If They are in seprate table just create flag in each table as Bleow:

'Recommended ' as Flag

in second table:

'non-Recommended' as Flag

ANd then concate both the files.

If in same qvd Then load first recommended data with flag and then non-Recommended and concate both files.

Thanks,

Arvind Patil

[agigliotti]

if( Recommended = 'Y', 'Recommended',

     if( non-Recommended = 'Y', 'non-Recommended' ) ) as Flag

[dolly777]

Hi Arvind,

I want to append Reccommended with 'Y' and non-Reccommended with 'N' in one field

Load

[Constrained $],

[Recommended $],

//if( [Constrained $] , ([Constrained $]  & '            N'),

  // if ([Recommended $], ([Recommended $]&'            Y'))) as [Rec/non-Rec],

Quote_Status

from SteeringRawData.xlsx

[arvind_patil]

Happy  to help you

Thanks,

Arvind Patil