topic Re: Where Clause in QlikView

Where Clause

Anonymous — Mon, 23 Jun 2014 09:15:11 GMT

HI All

I need help with the following

I am loading in

Load

%SaleId,

Sale.StartDate_Day as %SaleStartDate,

Sale.EndDate_Day aS %SaleEndDate_Day,

Sale.BrandName,

Sale.SaleId,

Sale.Currency,

Sale.BranchName,

Sale.Description,

Sale.SaleNameNumber,

Sale.HallNameNumber,

Sale.UserGroupCodeAtImport,

Sale.Name,

Sale.Channel,

Sale.Status,

Sale.UserGroupCode,

Sale.SaleGroup,

Sale.AllowAnonymousLotAccess,

Sale.PreviewDate,

Sale.PreviewDate_Day,

Sale.PreviewDate_Time,

Sale.StartDate,

Sale.StartDate_Day,

Sale.StartDate_Time,

Sale.ReminderDate,

Sale.ReminderDate_Day,

Sale.ReminderDate_Time,

Sale.EndDate,

Sale.EndDate_Day,

Sale.EndDate_Time,

Sale.xBidDate,

Sale.xBidDate_Day,

Sale.xBidDate_Time,

Sale.SalePhaseStartDate,

Sale.SalePhaseStartDate_Day,

Sale.SalePhaseStartDate_Time,

Sale.SalePhaseType,

Sale.DCF

FROM $(vQVDLOADPATH)Sale.qvd (qvd)

where Sale.BrandName = 'ALSpain' or 'ALItaly' or 'BCSpain' or 'BCItaly' And Sale.EndDate > '20/05/2014' And Sale.StartDate > '20/05/2014';

In the script but not getting the full results

Is this the best way to display the only selected data?

How can i write this with Set-Analysis to only load the Salebrands listed above in where clause?

Thanks

Re: Where Clause

maxgro — Mon, 23 Jun 2014 09:18:43 GMT

if you want to filter in the load (script) try with

where mixmatch(Sale.BrandName, 'ALSpain', 'ALItaly', 'BCSpain', 'BCItaly') And Sale.EndDate > '20/05/2014' And Sale.StartDate > '20/05/2014';

Re: Where Clause

PradeepReddy — Mon, 23 Jun 2014 09:26:34 GMT

Try the bellow condition...

Where (Sale.BrandName = 'ALSpain' or

Sale.BrandName= 'ALItaly' or

Sale.BrandName='BCSpain' or

Sale.BrandName= 'BCItaly')

And Sale.EndDate > '20/05/2014'

And Sale.StartDate > '20/05/2014';

we can achieve this in other way using Mixmatch(), as suggested by Massimo..

Regards,

Pradeep

Re: Where Clause

ashfaq_haseeb — Mon, 23 Jun 2014 09:27:19 GMT

Hi use match function.

Regards

ASHFAQ