topic Using conditions in Qlikview loading in QlikView

Using conditions in Qlikview loading

Tue, 19 Apr 2011 07:13:38 GMT

Hi,

I am Ravikumar ,

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

Using conditions in Qlikview loading

Anonymous — Tue, 19 Apr 2011 07:17:48 GMT

Hey there,

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

Load * from Consumption.csv where Litres>0;

Using conditions in Qlikview loading

tresB — Tue, 19 Apr 2011 07:19:02 GMT

Hi Ravi,

you can use WHERE as:

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

Regards, tresesco

Using conditions in Qlikview loading

Tue, 19 Apr 2011 07:20:46 GMT

HI,

T1:

LOAD C1,

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

Using conditions in Qlikview loading

Tue, 19 Apr 2011 07:22:30 GMT

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