Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

Logic to Find Value for Score1 and Score 2

I have to find score based on the logic :

If Customer 1 and A has 'O' in Check, but in Score 2 has 'X', then Score 1 total  should be 'O' and Score 2 total to be X.

Error.JPG

If Customer 1 and A has any 'X' in Check, Then Score 1  and Score 2 total to be X.

Error 1.jpg

Message was edited by: RAM MUTHIAH M

Message was edited by: RAM MUTHIAH M

9 Replies
chinnuchinni
Contributor III

Re: Logic to Find Value for Score1 and Score 2

can please attach the sample data and clear o/p which will you required ?

agigliotti
Honored Contributor II

Re: Logic to Find Value for Score1 and Score 2

what do you mean with 'A' ?

rammuthiah
Contributor II

Re: Logic to Find Value for Score1 and Score 2

It's just a flag to indicate where the data is from

agigliotti
Honored Contributor II

Re: Logic to Find Value for Score1 and Score 2

please show us what are the expressions you are using for SCORE1 and SCORE2 columns.

rammuthiah
Contributor II

Re: Logic to Find Value for Score1 and Score 2

Please find attached qvf

agigliotti
Honored Contributor II

Re: Logic to Find Value for Score1 and Score 2

what is your business logic for SCORE1 and SCORE2 columns?

what is your expected result?

rammuthiah
Contributor II

Re: Logic to Find Value for Score1 and Score 2

That I highlighted in the image in total column as 'O' and 'X'

agigliotti
Honored Contributor II

Re: Logic to Find Value for Score1 and Score 2

yes I see but what's the logic behind that results ?

rammuthiah
Contributor II

Re: Logic to Find Value for Score1 and Score 2

If A affects 'X' it reflects to 'B'(then Scroe1 and Score2 ->'X') also See 2nd image.

If Adoesn't affect 'O', but B->'X', then Score1 ->'O' and Score2'X'

Community Browser