Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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?.
I want to calculate/Logic the Issue Type name in script not in front end
Why? It looks unnecessary to me.
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
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
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?
I don't see why you need 16 expressions. One is enough. Just select the records you want counted.
I think my requirement is not clear.
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 |
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
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