topic Re: Replace the Combination Logic in QlikView

Replace the Combination Logic

nisha_rai — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Replace the Combination Logic

Gysbert_Wassenaar — Fri, 02 Dec 2016 06:58:33 GMT

It looks like you're trying to create some 'binary' like field where each 'bit' indicates an issue. Why? Such a field is extremely hard for a human to parse and understand. It's useless in charts and tables on dashboards.

Re: Replace the Combination Logic

nisha_rai — Fri, 02 Dec 2016 07:27:05 GMT

Thanks for your response,

Yes, I am agree with you , but after that we are using inline lable which is giving you the idea about what exactly the values say. For example:

0000- other

1000-Late

0200-Error

0030- Training

0004- Issue

1200-Late

1200-Error and so on

for 4 columns it's fine to create inline table but if tcolumn number increase from 4 to 8 then it's hard to create inline or excel table, that's why i want to replace that logic.

Re: Replace the Combination Logic

pathiqvd — Fri, 02 Dec 2016 07:28:07 GMT

Hi,

Try like this,

lOAD*,

IF(flag2=0004,'isuue',IF(flag2=0030,'Training',if(flag2=0200,'Error',if(flag2=1000,'Late','Other')))) as flag3;

LOAD *,

if(FLAG='Yes' , if (LATE>=1,1,0) & if (ERROR='Y',2,0)& if(TRAINING='Y',3,0)& if(ISSUE>=1,4,0)) as flag2

INLINE [

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

];

Re: Replace the Combination Logic

Gysbert_Wassenaar — Fri, 02 Dec 2016 07:30:09 GMT

Why do you need the inline table at all? You already have that information about which issues an ID has in the other table.

Re: Replace the Combination Logic

nisha_rai — Fri, 02 Dec 2016 07:32:19 GMT

Hi,

Suppose the value is 1200 then it's come under Late and Error both Type not in Other.

Re: Replace the Combination Logic

nisha_rai — Fri, 02 Dec 2016 07:34:47 GMT

We have one table only and in which is giving you the information about the id and those 4 fields.for showing the issue type we are creating the above logic and based on that bit number we are creating a inline table which is giving you the issue type name.

Re: Replace the Combination Logic

Gysbert_Wassenaar — Fri, 02 Dec 2016 07:36:55 GMT

Yes, so? All the user sees is a number like 12045078. And from that the users supposed to see Oh, that's Late and it's an Error and it's an Issue and some other things too? Why? Just look at the first table and you can see in a glance which issues an ID has.

Re: Replace the Combination Logic

nisha_rai — Fri, 02 Dec 2016 07:42:37 GMT

Hi,

we are showing issue type name field.

Example:

Issue_Type Name

Error

Issue

Training

Late

id- 6 comes under Late and Error.

User want the count of id in corresponding issue type name.

Means : How many id comes under late,Error and so on

Re: Replace the Combination Logic

Gysbert_Wassenaar — Fri, 02 Dec 2016 07:48:35 GMT

You can do that with the original table. Simply select the value 1 in a listbox with Late as field and you'll get the id's that are late. Or use an expression like count({<Late={1}>}ID).

Re: Replace the Combination Logic

nisha_rai — Fri, 02 Dec 2016 07:55:37 GMT

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.

Re: Replace the Combination Logic

Gysbert_Wassenaar — Fri, 02 Dec 2016 07:58:43 GMT

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?.

Re: Replace the Combination Logic

nisha_rai — Fri, 02 Dec 2016 08:01:58 GMT

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

Re: Replace the Combination Logic

Gysbert_Wassenaar — Fri, 02 Dec 2016 08:05:55 GMT

Why? It looks unnecessary to me.

Re: Replace the Combination Logic

pathiqvd — Fri, 02 Dec 2016 08:06:32 GMT

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

Re: Replace the Combination Logic

nisha_rai — Fri, 02 Dec 2016 08:12:06 GMT

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

Re: Replace the Combination Logic

nisha_rai — Fri, 02 Dec 2016 08:14:25 GMT

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?

Re: Replace the Combination Logic

Gysbert_Wassenaar — Fri, 02 Dec 2016 08:30:27 GMT

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

Re: Replace the Combination Logic

nisha_rai — Fri, 02 Dec 2016 08:53:27 GMT

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

Re: Replace the Combination Logic

nisha_rai — Fri, 02 Dec 2016 09:15:15 GMT

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