Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to write WHERE condition in Qlikview? after joining the all the QVDs?
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
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';
not like this...I have to add four qvds then after all qvds I want to add where condition to my data.
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';
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
Having list box and making selections on them can be a simple where condition.
thanks,
Rajesh Vaswani