CASE Expressions

[appi_priya]

HI

Can somebody please help me to fix the below sql expression in qlikview?

Select case when revenue_flag=1 and revenue_amount is not null then null else revenue_amount end as display from HR_LOG.EP_LB_LOG

Thanks

[Anonymous · Accepted solution]

your welcome priya
you can mark correct/helpfull answer if my replies did helped you

[appi_priya]

Hi Robert,

I realized that I was using the script wrongly and checked that after placing the condition in the preceeding load with the LOAD statement I got the desired result.

Thank you so much for the help.