Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

if condition

is it possible to have like an if condition as below

if(match(country name, then A and B else C

A

B

C  are 3 different values in one table.

10 Replies
sunny_talwar

So basically if the Country name is France, you want to create two rows for it... one with the value Legal and the second one with processed?

May be try with link table

LinkTable:

LOAD DISTINCT [Country name],

     If([country name] = 'France', 'Legal', 'unauthorized') as Flag

Resident ....;

Concatenate (LinkTable)

LOAD [country name],

     'processed' as Flag

Resident ...

Where [country name] = 'France';