Using conditions in Qlikview loading

[#1]

Hi,

I am Ravikumar ,

How to use the conditions like(where) In qlikview loading ...

[Anonymous · Accepted solution]

Hey there,

Here's an example from the F1-Help in QlikView:

Load * from Consumption.csv where Litres>0;

[tresesco]

Hi Ravi,

you can use WHERE as:

LOAD .......... FROM ..........WHERE <your condition>;

Regards, tresesco

[#4]

HI,

T1:

LOAD C1,

C2

FROM

D:\Upendra\Book1.xlsx (ooxml, embedded labels, table is Sheet1)

where C1>'15';

Table contains

C1 C2

11 IND

12 USA

15 RSA

25 OMN

299 BRH

100 QTR

Thanks & Regards

[#5]

Hi Ravi,

You can apply these condition when you are trying to extract data from data source or in the script of QVD Generator or QVD Extractor,

Please have a look at this example :

Specialisation:
Load DISTINCT *;
SQL SELECT *
FROM AHISAPOLLO.dbo.Specialisation
where Year(StartDatetime) = Year(GETDATE())-1 ;
store Specialisation into [..\DataSources\QVDOLD\Specialisation_Tab.QVD](qvd);
DROP TABLE Specialisation;

This is the simple example for where condition .

I think that will serve your purpose.

Best of luck..........

Regards,

Dushyant

mail me at dushyant.ntpc@gmail.com