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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Nakosan
Contributor II
Contributor II

Conditional statement if set number code, return another measure

Hi, I'm new to qlik and haven't coded anything for a while.

Trying to make a statement where if the transaction type equals to 11 (the withdrawal code), it returns the date (of registration, which equals to the withdrawal date).

If[Transaction type] = 11, [Registration date], 'Other'

I'm unsure of how to make this simple syntax work as I've mostly done the visualization parts till now

Labels (2)
1 Solution

Accepted Solutions
Nakosan
Contributor II
Contributor II
Author

Lol I apparently just needed some brackets

if ([Transaction type] = 11, `[Registration date]`, 'Other') WORKED FINE 🙂 

View solution in original post

1 Reply
Nakosan
Contributor II
Contributor II
Author

Lol I apparently just needed some brackets

if ([Transaction type] = 11, `[Registration date]`, 'Other') WORKED FINE 🙂