Discussion board where members can get started with QlikView.
I am bit new to QV and I am stucked in wrighting data load script to achieve above final result
Intermediate Result After Join Itself
I can solve it by Sql Query like select * from tab1 a inner join tab1 b on a.fld1=b.fld1 and b.fld2<=a.fld1
I know in QV we can join 2 tables on a single common field directly it not possible in QV, so please provide me the wayout for it.
Thanks In Advance
Go to Solution.
Directly It is not possible in QV, But as you say that you can wright query. then why you don't use it with SQL prefix
I think, you have to do it in two steps in QV, for example: join load, then load with 'where' statement.
hi, Thanks for your reply, but can you please explain more.
Please Explain properly.
( Your Query ) ;
QV performs joins in a slighly different way.
On the first join 'where' statement applys to the source while you want to apply it to the result.
So you need to split your SQL select into two loads.
If you get your data from sql you can perform that query with sql statement in QV.
Simple Question is your sample table(Intermediate Result After Join Itself) is looks like the same type of data that you posted? I mean the empty values in Code, Date and Amount field?
hi Celambarasan, nothing is empty in IInd table, both IInd & IIIrd look like.
Then you can try with this
FirstValue(Date) AS Date,
Sum(Amount1) AS Amount1
Group by Code;
Hope you understand