Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

applying multiple conditions on qvd

hi

i have the script am loading data from QVD

LOAD Month,

     [Salesman ID],

     [Customer ID],

     [Transaction ID],

     Year,

     Day,

     [Product ID],

     [Serial No],

     [List Price],

     Sales,

     [Gross Margin]

FROM

(qvd)where Year=2008 and [Product ID]=2000 ;

i need this out put:

Sales  of

YEAR=2008,2006 and [Product ID]=2000,1000

Tags (2)
1 Solution

Accepted Solutions

Re: applying multiple conditions on qvd

Hi,

Try below

LOAD Month,

     [Salesman ID],

     [Customer ID],

     [Transaction ID],

     Year,

     Day,

     [Product ID],

     [Serial No],

     [List Price],

     Sales,

     [Gross Margin]

FROM

(qvd)where match(Year'2008','2006') and match([Product ID],'2000','1000');

Regards

ASHFAQ

View solution in original post

4 Replies

Re: applying multiple conditions on qvd

LOAD Month,

     [Salesman ID],

     [Customer ID],

     [Transaction ID],

     Year,

     Day,

     [Product ID],

     [Serial No],

     [List Price],

     Sales,

     [Gross Margin]

FROM

(qvd)where (Year=2008 or Year=2006) and ([Product ID]=2000 or [Product ID]=1000);

let me know

Re: applying multiple conditions on qvd

Hi,

Try below

LOAD Month,

     [Salesman ID],

     [Customer ID],

     [Transaction ID],

     Year,

     Day,

     [Product ID],

     [Serial No],

     [List Price],

     Sales,

     [Gross Margin]

FROM

(qvd)where match(Year'2008','2006') and match([Product ID],'2000','1000');

Regards

ASHFAQ

View solution in original post

Re: applying multiple conditions on qvd

Load your script like

LOAD Month,

     [Salesman ID],

     [Customer ID],

     [Transaction ID],

     Year,

     Day,

     [Product ID],

     [Serial No],

     [List Price],

     Sales,

     [Gross Margin]

FROM

(qvd)

where ( Match(Year,'2008','2006') and Match([Product ID],'2000','1000') );

Re: applying multiple conditions on qvd

Hi,

Try with wildmatch() also

Like

where Wildmatch(Year,'2008','2006') and Wildmatch([Product ID],'2000','1000')

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.