Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
use
where match([Month],'Jan','Feb','Mar',Apr','May')
Regards
Nitin
LOAD
[AGENT],
SALES AS SALES,
[Month] ,
FROM
(biff, embedded labels)
WHERE match([Month],'Jan','Feb','Mar','Apr');
Thanks u soo much nitin it is working .. thanks a lot for ur support