topic Load one value in QlikView

Load one value

gidon500 — Sat, 22 Aug 2015 07:25:36 GMT

hi guys

I have a data that I need to load one value OF A , no matter which line

A B C

1 3 5

2 6 7

1 5 9

2 9 5

I need the result to be

A B C

1 3 5

2 6 7

thanks

gidon

Kushal_Chawda — Sat, 22 Aug 2015 08:12:01 GMT

Data:

LOAD *,RecNo() as Rec Inline [

A , B, C

1, 3, 5

2, 6, 7

1, 5 , 9

2, 9 , 5 ];

Inner Join

LOAD A,

min(Rec) as Rec

Resident Data

Group by A;

petter — Sat, 22 Aug 2015 08:50:23 GMT

Data:

LOAD

FirstValue(B) AS B,

FirstValue(C) AS C,

RecNo() AS Rec

INLINE [

A, B, C

1 , 3, 5

2 , 6, 7

1 , 5 , 9

2, 9 , 5

]

GROUP BY

gidon500 — Sat, 22 Aug 2015 09:04:45 GMT

thanks it works

gidon