Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
your welcome priya
you can mark correct/helpfull answer if my replies did helped you
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.