how to write WHERE condition in Qlikview? after joining the all the QVDs?

[#1]

how to write WHERE condition in Qlikview? after joining the all the QVDs?

[its_anandrjs]

Hi,

You have to use Where Clause at the end of load statement some of the way like

Ex:-

1.

SELECT `Order Details`.`Order ID`,

Sum(`Order Details`.`Unit Price` * `Order Details`.Quantity) as `Result`

FROM `Order Details`, Orders

where Orders.`Order ID` = `Order Details`.`Order ID`

group by `Order Details`.`Order ID`;

2.

Load * From Source Where  Date <= Today();

Regards

Anand

[#3]

Hi,

like this

t1:

load  * inline [

date,amount

1/1/2014,1000

2/1/2014,2000

3/1/2014,3000

4/1/2014,4000

5/1/2014,5000

6/1/2014,6000

];

for example u have table called t1 and fields are like date,amount.

where condition u can use like this

load

*

from t1

where date>='3/1/2014';

[#4]

not like this...I have to add four qvds then after all qvds I want to add where condition to my data.

[#5]

try like this

T1:

load qvd1:

concatenate

laod qvd2;

concatenate

load qvd3;

concatenate

load qvd4

store T1 into  c:\...\T1.qvd

where date>='3/1/2014';

[its_anandrjs]

Hi,

Then try like

AllQvd:

Load * From Qvd1.qvd;

concatenate

Load * From Qvd2qvd;

concatenate

Load * From Qvd3.qvd;

concatenate

Load * From Qvd4.qvd;

Noconcatenate

Load * Resident AllQvd Where Condition;

Drop Table AllQvd;

And what is your where condition

Regards

Anand

[rajeshvaswani77]

Having list box and making selections on them can be a simple where condition.

thanks,

Rajesh Vaswani