# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for
Did you mean:
Creator II

## Need Output based on logic given below

DATA_1:

Supplier, C1, C2,

A, 100, 100,

A, 200, 200,

A, 300, 250,

];

DATA_2:

Customer, C1, C2,

B, 300, 300,

B, 250, 250,

B, 600, 600,

];

I need the logic based on the Scenario 1 and 2:

 Scenario 1 Supplier/Customer C1 C2 Check 1 Check 2 Check(if isnull(Check1),Check 2,Check 1)) Score A 100 100 TRUE TRUE FALSE A 200 200 TRUE TRUE FALSE A 300 250 FALSE FALSE FALSE B 300 300 TRUE TRUE FALSE B 250 250 TRUE TRUE FALSE B 600 600 TRUE TRUE FALSE Scenario 2 Supplier/Customer C1 C2 Check Score A 100 100 TRUE TRUE A 200 200 TRUE TRUE A 300 300 TRUE TRUE B 300 300 TRUE FALSE B 250 250 TRUE FALSE B 600 500 FALSE FALSE
8 Replies
MVP

Which column are you looking to calculate?

Creator II
Author

Score Column. Score result based on Supplier/Customer column.

MVP

So, couple of questions

1) What is the logic behind the outputs you are seeing in the two scenarios?

2) Why 2 scenarios? You need two tables with different logics?

Partner

Try this for first scenerio:

test:

if(C1=C2,'True','false') as check1,

'Supplier' as Flag1;

Supplier, C1, C2,

A, 100, 100,

A, 200, 200,

A, 300, 250,

];

Concatenate

DATA_2:

if(C1=C2,'True','false') as check2,

'Customer' as Flag2;

Supplier, C1, C2,

B, 300, 300,

B, 250, 250,

B, 600, 600,

];

if(IsNull(check1),check2,check1) as Result

Resident test;

drop table test;

Partner

Creator II
Author

Value for the table is from 2 tables. For instance Cost from supplier 1 and supplier 2

Actual Supplier1 - 80

Actual Supplier2 - 60

We have a target for supplier

Target for Supp 1 : 70

Target for Supp 2 : 70

Comparing those results in Check 1 for A and Check 2 for B. We can’t bring those in a single. So that I have used “Check(if isnull(Check1),Check 2,Check 1))” to bring all values in Single column.

Say like Supp1 is main, if it fails to achieve the task, then both will result in Fail.

But Supp 2 is comes under of Supp1, if it fails to achieve the task, but not Supp1, will result in Pass category

Creator II
Author

I need this in a single table

Creator II
Author

Kindly scroll to the right side of my requirement