Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
nisha_rai
Creator II
Creator II

Replace the Combination Logic

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 :

   

IdLateErrorTrainingIssueFlag
1No
21Yes
3YYes
4YYes
51Yes
61YYes
71YYes
811Yes
9YYYes
101YY1Yes

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

20 Replies
nisha_rai
Creator II
Creator II
Author

Ok..Suppose issue type increases (i.e. 16 Column ) which is giving you the information about that issue type .

Then we have to create the 16 expression.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You would have to do that too if you wanted to count id's with values like 1204507809-10-11-12-00-00-15-16: count({<Issue_Type={"1204507809-10-11-12-00-00-15-16"}>ID}.

Why not simply let the user select what they want to see?.


talk is cheap, supply exceeds demand
nisha_rai
Creator II
Creator II
Author

I want to calculate/Logic the Issue Type name in script not in front end

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Why? It looks unnecessary to me.


talk is cheap, supply exceeds demand
pathiqvd
Creator III
Creator III

Hi,

  Like that add in if condition whatever types you want suppose

if(flag2=1200,'Late and error',if(flag2=0230,'Error and Traing',.....))

like that write in if logic

nisha_rai
Creator II
Creator II
Author

because each and everthing is done in backend , in front end they have simple expression.we we are using expression for Issue type then we have to create 16 expressions  . or if in future issue type increases then again create a new expression for those also

nisha_rai
Creator II
Creator II
Author

Hi,

We have only for 4 issue type , we can't show it as Late & Error or Error & Training.

if condition is easy for 2 or 4 column , if we have 27 coulmn then what?

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I don't see why you need 16 expressions. One is enough. Just select the records you want counted.


talk is cheap, supply exceeds demand
nisha_rai
Creator II
Creator II
Author

I  think my requirement is not clear.

   

IdLateErrorTrainingIssueFlag
1No
21Yes
3YYes
4YYes
51Yes
61YYes
71YYes
811Yes
9YYYes
101Y

Y

1Yes

Result:

Filed :

   

Root Cause
Late
Error
Training

Issue

Chart :- Bar chart Date as dimension

Late  5

Error  4

Training 4

Issue 3

so, will you please tell me how i can get that result from single expression

nisha_rai
Creator II
Creator II
Author

Hi,

I want the below as a result

Result:

Filed :

   

Root Cause
Late
Error
Training

Issue

Chart :- Bar chart Date as dimension

Late  5

Error  4

Training 4

Issue 3

so, will you please tell me how i can get that result from single expression