Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
I am facing some problem on doing Hard Coding in Qlikview.
I am able to Hard Code in the scrip if I am importing the Excel data in Qlik View ,but when I Hard Code in the Script which is connected to the database I got error, Please tell me the right way to hard code.
Please find the attachment for details.
Regards,
Him
Hi,
If loop cann't be used in SQL SELECT Try this
Load *,if(New_LeadCategory=1,'aaa','NewLeadCategory') as New_LeadCategory_1;
SQL Select
.
.
.
From datasource;
Note:Remove the if loop in the SQL Select
Celambarasan
Hi,
If loop cann't be used in SQL SELECT Try this
Load *,if(New_LeadCategory=1,'aaa','NewLeadCategory') as New_LeadCategory_1;
SQL Select
.
.
.
From datasource;
Note:Remove the if loop in the SQL Select
Celambarasan
Dear Celambarasan,
Thanks for the reply,Plz tell me the expression if i have to print
New_LeadCategory=1 then aaa ,
New_LeadCategory=2 then bbb and
New_LeadCategory=3 then ccc for the same below line..
{{ Load *,if(New_LeadCategory=1,'aaa','NewLeadCategory') as New_LeadCategory_1;}}}
Regards,
Him
Hi,
Change the if loop to
if(New_LeadCategory=1,'aaa',if(New_LeadCategory=2,'bbb',if(New_LeadCategory=3,'ccc')))
Celambarasan
thanks...