Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

if Variable = x then y

Hi, 

I need to create a new variable within my Data Manager using an IF Statement but unsure how to go about writing it. 

I need it to say:

if(Purchase_order = 'RT' and Dist_type<> '', Dist_type, Purchase_order )

Any idea on the correct Qlik syntax for this please as it the calculated field doesn't appear to like 'and'?

 

2 Replies
Highlighted
MVP
MVP

It seems odd - I don't use Data Manager much so I gave it a go and you're right it doesn't accept AND although the documentation suggest that If is a valid data manager expression function that should behave like any other If() in the load script or a chart ...

However you can nest the If like this:

If( Purchase_order = 'RT' , If( Dist_type<>'' , Dist_type , Purchase_order), Purchase_order)

  or

If( Puchase_order&'|'&Dist_type <> 'RT|' , Dist_type , Purchase_order)

 

 

 

Highlighted
MVP
MVP

A third work-around is to sum the boolean values of the comparisons as a true value is -1 and a false value is 0:

If( ((Purchase_order='RT') + (Dist_type<>''))=-2 , Dist_type, Purchase_order )

doesn't work however since the expression parser in the Data Manager is rather simplistic - so you have to use paranthesis around a lot of sub-expressions and even negative numbers - this works however:

 

If( ((Purchase_order='RT') + (Dist_type<>''))=(-2 ), Dist_type, Purchase_order )