Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

Score Card Logic

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

Error.JPG

1 Solution

Accepted Solutions
rammuthiah
Contributor II

Re: Score Card Logic

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.

3 Replies
krishna_2644
Valued Contributor III

Re: Score Card Logic

Could you please be more spcific and clear?

rammuthiah
Contributor II

Re: Score Card Logic

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)

rammuthiah
Contributor II

Re: Score Card Logic

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.

Community Browser