Discussion board where members can get started with Qlik Sense.
Load * Inline [
Supplier, C1, C2,
A, 100, 100,
A, 200, 200,
A, 300, 250,
Customer, C1, C2,
B, 300, 300,
B, 250, 250,
B, 600, 600,
I need the logic based on the Scenario 1 and 2:
Check(if isnull(Check1),Check 2,Check 1))
Which column are you looking to calculate?
Score Column. Score result based on Supplier/Customer column.
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?
Try this for first scenerio:
if(C1=C2,'True','false') as check1,
'Supplier' as Flag1;
if(C1=C2,'True','false') as check2,
'Customer' as Flag2;
if(IsNull(check1),check2,check1) as Result
drop table test;
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
I need this in a single table
Kindly scroll to the right side of my requirement