Discussion board where members can learn more about Qlik Sense deployments on Public Cloud Infrastructures such as AWS and Azure.
Can please convert the IF code to case.
If(columnA='RAV', If(columnC> 9, 'RAV After 7 Days', 'RAV Till 7 Days'),
If(columnA='TOT/ODv', If(columnB='OVD', If(columnC> 5,'OVD After 3 Days', 'OVD Till 3 Days')
,'TOT'), columnA)) AS New,
The case statement in Qlik are control statements and thus can not be used in Load statement.
Do you have any specific reason why you want to go for Case Statement.
We are using it in Select statement
I would recommend use of If statement then case statement.
So in your case instead of using the Case statement in Select statement, you should use the If statement in load statement like below.
,'TOT'), columnA)) AS New;
Sql Select * from xyz;