Select Excluded in the Concat field

Thu, 08 Oct 2009 03:24:03 GMT

Consider the below example :

I have problem in the Select excluded in the concat field StatusGroup

StatusGroup field if I want to exclude only AAA values only

AAA
AAA EEE RRR
AAA FFF HHH

TEMP:
LOAD * INLINE [
OrderNo,Status
101, AAA
102, BBB
101, EEE
102, CCC
101, RRR
103, FFF
104, DDD
103, HHH
103, AAA
104, BBB
105, EEE
105, JJJ
106, AAA
107, BBB
108, RRR
109, HHH
110, EEE
];

Temp1:
LOAD
OrderNo,
Concat(DISTINCT Status,' ') AS StatusGroup
resident TEMP
group by OrderNo
order by Status;

If I select AAA value from Status and exclude is excluding only AAA value in the StatusGroup field

I am expecting to exclude all the 3 values

AAA
AAA EEE RRR
AAA FFF HHH

Advance thanks for your help.

Select Excluded in the Concat field

Thu, 08 Oct 2009 05:48:26 GMT

Hi,

I don"t really understand what you"re trying to do.

Qlikview reflects the correct results when you exclude all AAA Status for example because you have multiple OrderNo with same status and same OrderNo with different Status this is why when you Exclude the value of AAA you still have AAA EEE RRR and AAA FFF HHH. This is because they are linked to other OrderNo and other status.

You need to redefine your shema depending on the purpose of your application.

Rgds

topic Select Excluded in the Concat field in QlikView

Select Excluded in the Concat field

Select Excluded in the Concat field