Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
FrankSl
Contributor
Contributor

Conditional Concatenation

Hi all!

 

Hope someone can help me out with the following:

Im trying to concatenate 2 loads but only depending on the condition that the dataset contains 1 of 3 possible values. Id the dataset doesnt contain that value, I want only to output the first load, without concatenation. 

I have tried the following, but the result show no concatetaned data at all, in not one resultset. 

Any thoughts? Thansk in advance!

 

Script:

Load
Value1,
Value2,
TITEL_DESC

Resident Data
Where $(sql)

order by TITEL_DESC
ASC;

If
match (TITEL_DESC,'title1', 'title2', 'title3')
then
Concatenate
load
Value1,
Value2,
TITEL_DESC

Resident Data
where TITEL_DESC = 'TitleX'
order by TITEL_DESC
ASC
;

else
Load
Value1,
Value2,
TITEL_DESC

Resident Data
Where $(sql)
order by TITEL_DESC
ASC;
endif;

Labels (1)
1 Reply
sidhiq91
Specialist II
Specialist II

@FrankSl  is it possible for you to provide some data set for us to work on it?