topic Problem In Hard Code in QlikView

Problem In Hard Code

Wed, 21 Mar 2012 07:36:39 GMT

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

Problem In Hard Code

CELAMBARASAN — Wed, 21 Mar 2012 07:46:31 GMT

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

Problem In Hard Code

Wed, 21 Mar 2012 08:45:51 GMT

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

Problem In Hard Code

CELAMBARASAN — Wed, 21 Mar 2012 08:56:49 GMT

Hi,

Change the if loop to

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

Celambarasan

Problem In Hard Code

Wed, 21 Mar 2012 09:58:44 GMT

thanks...