Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ravikumar_iyana
Creator
Creator

I want to create a flags in the field values

Hi ,

you can please help me , I have a field name "rate".

I want to create a flag for in a field rows

  1. Startig the field with "1" means i will show to "Born by Company".
  2. Startig the field with "2" means i will show to "Born by vendor"
  3. Remaining same numbers will display.

rate

1d
1e
1c
2a
2g
2k
4
5

Thanks,

Ravi.

17 Replies
Chanty4u
MVP
MVP

tried this still no luck

pick( 1+WildMatch(rate,'1*','2*'),

                   'Bom', 'Newb',rate) as Group;

sergeyay
Contributor III
Contributor III

Hi

Is it right result?

code:

[tmp]:

LOAD

    Rate,

    if (Left(Rate, 1) = '1', 'Born by Company', if (Left(Rate, 1) = '2', 'Born by vendor', Rate)) as _flag;

LOAD * INLINE [

    Rate

    1d

    1e

    1c

    2a

    2g

    2k

    4

    5

];

chinnuchinni
Creator III
Creator III

load *,if(Left(Rate,1)=1,'Born by Company',if(Left(Rate,1)= 2,'Born by vendor',Rate))as Rate1 Inline [

Rate

1d

1e

1c

2a

2g

2k

4

5

];


EXIT SCRIPT ;

chinnuchinni
Creator III
Creator III

294818.PNG

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Youssef,

I think perhaps you meant to put the default (rate) as the first pick?

pick(wildmatch(rate,'1*','2*')+1, rate, 'Born by Company',' Born by vendor') as rate

-Rob



YoussefBelloum
Champion
Champion

Thank so much for your time

Anonymous
Not applicable

try this on the graphic object...

if(pick(Left(Rate,1), 'Born by Company','Born by vendor',Rate) > 0,

   pick(Left(Rate,1), 'Born by Company','Born by vendor',Rate), Rate)

Chanty4u
MVP
MVP

Nice Rob thanks for the clarification