How to Restrict values in excel in load

[Anonymous]

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);

[Anonymous]

use

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

Regards

Nitin

[Gysbert_Wassenaar]

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

[Anonymous]

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