topic Re: How to Restrict values in excel in load in QlikView

How to Restrict values in excel in load

Anonymous — Tue, 24 Dec 2013 07:27:15 GMT

Hi all,

I am having one excel file that has a month field from Jan to Dec but I need to load only 5 months (i.e Jan,Feb,Mar,Apr,May) how I will over come this . in SQL we will use 'IN' function but Qlik view how we will manage this..

if I try like this in the way as I shown below it is showing expected exception ); error

load

[AGENT],

SALES AS SALES,

[Month] ,

FROM

//(biff, embedded labels) where [Month]=('Jan','Feb','Mar',Apr);

Re: How to Restrict values in excel in load

Anonymous — Tue, 24 Dec 2013 07:30:06 GMT

use

where match([Month],'Jan','Feb','Mar',Apr','May')

Regards

Nitin

Re: How to Restrict values in excel in load

Gysbert_Wassenaar — Tue, 24 Dec 2013 07:30:59 GMT

LOAD
     [AGENT],
     SALES AS SALES,
     [Month] ,
FROM 
(biff, embedded labels)
WHERE match([Month],'Jan','Feb','Mar','Apr');

Re: How to Restrict values in excel in load

Anonymous — Tue, 24 Dec 2013 07:34:55 GMT

Thanks u soo much nitin it is working .. thanks a lot for ur support