Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

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
Creator III
Creator III

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

agigliotti
Partner - Champion
Partner - Champion

what do you mean with 'A' ?

rammuthiah
Creator III
Creator III
Author

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

agigliotti
Partner - Champion
Partner - Champion

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

rammuthiah
Creator III
Creator III
Author

Please find attached qvf

agigliotti
Partner - Champion
Partner - Champion

what is your business logic for SCORE1 and SCORE2 columns?

what is your expected result?

rammuthiah
Creator III
Creator III
Author

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

agigliotti
Partner - Champion
Partner - Champion

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

rammuthiah
Creator III
Creator III
Author

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'