How to obtain values present in all 5,4,3,2 and in 1 table?

[Anonymous]

I am new to QlikView and I have been assigned to obtain the values which are present in all 5 tables, present only in any 4, 3, 2 tables and the values which are unique among all the 5 tables.

Kindly help me out with this issue.

[devarasu07]

Hi,

simply alias column name & Concatenate method should work. thanks

u can try like this

Fact:
LOAD EYE_VIN as Category
FROM

(ooxml, embedded labels, table is EYE_Sentiment);
Concatenate
LOAD BP_VIN as Category
FROM

(ooxml, embedded labels, table is PSF_BP_Sentiment);
Concatenate
LOAD GS_VIN as Category
FROM

(ooxml, embedded labels, table is PSF_GS_Sentiment);
Concatenate
LOAD NCDS_VIN as Category
FROM

(ooxml, embedded labels, table is NCDS_Sentiment);
Concatenate
LOAD VOC_VIN as Category
FROM

(ooxml, embedded labels, table is VOC_Sentiment);

[MarcoWedel]

Hi,

maybe one solution could be:

FOR i = NoOfTables()-1 to 0 STEP -1
  LET vTable=TableName($(i));
  tabFieldValues:
  CrossTable (Field,Value)
  LOAD '$(vTable)' as Table, * Resident $(vTable); 
NEXT i

hope this helps

regards

Marco