please help to implement logic

vipin_mishra479 — Tue, 15 May 2012 04:54:53 GMT

i have a 10 record and there have a different data

eg.

1 - doc

1 - koc

1 - noc

same as 2, 3 ,4 ,5 ,6, 7 ,8,9, 10

if i want to data 1 to 9 all data doc , koc and noc but in 10 i want to only koc data then how can i implement the logic

please help to implement logic

Tue, 15 May 2012 07:29:01 GMT

Hi,

You can do it in the following way:

Test:
LOAD * INLINE [
F1, F2
1, doc
1, koc
1, noc
2, doc
2, koc
2, noc
3, doc
3, koc
3, noc
4, doc
4, koc
4, noc
];

Test1:
LOAD
F1 AS record,
F2 AS data
RESIDENT Test
WHERE F1 <> 4;
JOIN
LOAD
F1 AS record,
F2 AS data
RESIDENT Test
WHERE F1 = 4
AND F2 = 'doc';

Regards vicky

topic please help to implement logic in QlikView

please help to implement logic

please help to implement logic