Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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';