Replace the Combination Logic

[nisha_rai]

Hi,

I am new in qlikview ,please help me to resolve the issue

we have one table in which we have 4 column based on the combination of 4 column we are creating the new coulmn.

I want to replace the combination logic in other one.

for example:

table1 :

Id	Late	Error	Training	Issue	Flag
1					No
2	1				Yes
3		Y			Yes
4			Y		Yes
5				1	Yes
6	1	Y			Yes
7	1		Y		Yes
8	1			1	Yes
9		Y	Y		Yes
10	1	Y	Y	1	Yes

want to replace the below formula if(Flag='Yes' , if (Late>=1,1,0) & if (Error='Y',2,0)& if(Training='Y',3,0)& if(Issue>=1,4,0)) as Issue_Type

now we have only 4 column then it's easy to use permutation and combination logiv but in future if the column will increase from 4 to 8 then we have to create  so many combination name manulaay is difficult.

Thanks in advance

Regards,

Nisha

[Gysbert_Wassenaar]

Load the data:

CrossTable(Issue_Type,Dummy)

LOAD * FROM ...source... WHERE Flag='Yes';

DROP FIELD Dummy;

Count the Id's: count(Id)