Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akshaye_c_navale

CASE..WHEN expression in Qlik Data Catalyst i.e. Data Catalog within Data Prep

Hi Community,

In one of my Data Prep Data Flow i want to convert below ternary expression into CASE..WHEN expression.

( TO_INTEGER ( Row_ID ) > 300 ? '>300' : ( TO_INTEGER ( Row_ID ) > 100 ? '>100' : 'Others') )

Can you please help me to write CASE..WHEN expression since i have multiple conditions.

Does anyone know how to create range buckets?

Thanks,
Akshaye

Labels (2)
2 Replies
felcar2013
Partner - Creator III
Partner - Creator III

hi, maybe this..

IF( Row_ID > 300,  '>300',

   IF( Row_ID > 100  AND Row_ID <= 300, '>100' ,

 'Others') ) AS YOUR_FIELD_DIM

_range buckets, depends how do want to use it, maybe a new table, have you checked interval match?

best

 

akshaye_c_navale
Author

Hi @felcar2013 ,

Thanks for reply.
I am looking to implement it within Qlik Data Catalyst.

Thanks,
Akshaye