topic Re: applying multiple conditions on qvd in QlikView

applying multiple conditions on qvd

Mon, 14 Jul 2014 13:10:18 GMT

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

Re: applying multiple conditions on qvd

alexandros17 — Mon, 14 Jul 2014 13:11:46 GMT

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

ashfaq_haseeb — Mon, 14 Jul 2014 13:15:02 GMT

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

Re: applying multiple conditions on qvd

its_anandrjs — Mon, 14 Jul 2014 13:15:28 GMT

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

PrashantSangle — Mon, 14 Jul 2014 15:13:28 GMT

Hi,

Try with wildmatch() also

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

Regards,