Discussion board where members can get started with QlikView.
Hi Every one,
I have 3 fields in a table A,B,C.
i need to load distinct of A values and also i need 3 fields.
if i keep
load distinct A, B, C from xyz;
it is giving only the distinct rows.
please help me on this.
Can you share sample data and expected output.
If you need Only Distinct A but with other 2 Fields. What will be the criteria to filter other 2 columns?
Because if load Distinct A and Left join B and C to A then again it will duplicate values from A.
Actually in A we have data 1,2,3,4,5,6.........some fields are repeated
In B we have data 1,2,3,.........which are repeated
In C we have date which are associate dates which are repeated.
now i want the out put : distinct A values ,min(C) dates,associate B values
Load * inline [
A as AA,
B as BB,
C as CC
Where Previous(A) <> A
Order by A