Discussion board where members can get started with QlikView.
can any one please help me on this.
I have p.product1 field in my oracle database. I have to convert null values in p.product1 to NULL text like if p.product1 = ' ' then it ned to show NULL text else p.product1.
Please help me to write the syntax under select statement only.
In the ODAG the selections are coming from one app to another app.
to_Char(p.date,'DD/MM/YYYY') as p.date,
from product p where to_Char(p.date,'DD/MM/YYYY') in $(WHEREPART);
in this $(WHEREPART) i am passing 10/05/2018 from selection app by creating subroutine on top.
Already by using oracle syntax in p.date 10/05/2018 00:00:00 is converted to 10/05/2018 then it will reload the app.
Same like by using oracle syntax i am looking for how to convert null values in p.product1 field into NULL text from selection app i will pass NULL text into here.
Converting in Load not working for odag.
Could you please help me on this.
Thanks in advance.
Did you try
Case When LENGTH(TRIm(p.product1)) =0 then 'NULL' else p.product1 End as p.product1
View solution in original post
nvl (p.product1,' '),
you can also try like this,