Problem In Hard Code

[#1]

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

[CELAMBARASAN · Accepted solution]

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 

[#3]

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

[CELAMBARASAN]

Hi,

     Change the if loop to

     if(New_LeadCategory=1,'aaa',if(New_LeadCategory=2,'bbb',if(New_LeadCategory=3,'ccc')))

Celambarasan

[#5]

thanks...