Discussion board where members can get started with Qlik Sense.
Need logic for this below image. I tried but couldn't make it possible. Please find attached qvf
1 - CustomerID
A - Customer
B - Internal
If I select any customer, it should be shown like below scenario(CustomerID : 1 or 2 or 3....)
Scenario 1 : If Check for any A is X-> Score 1 = X , Score 2 = X
Scenario 2 : If Check all A is O-> Score 1=O and
If Check for any B is X-> Score 2= X
Go to Solution.
I have done this logic.
By using segregation of Check based on the value and merge it in a single table solves all the problem.
Could you please be more spcific and clear?
For each project #(for eg. 1 has A and B. If A has any X by comparing the value C1 and C2, Then Score 1 and Sore 2 shoould be X, if no X for A and X for B, then Score 1 should be O and Score 2 should be X)