Discussion board where members can get started with Qlik Sense.
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.
If Customer 1 and A has any 'X' in Check, Then Score 1 and Score 2 total to be X.
Message was edited by: RAM MUTHIAH M
can please attach the sample data and clear o/p which will you required ?
what do you mean with 'A' ?
It's just a flag to indicate where the data is from
please show us what are the expressions you are using for SCORE1 and SCORE2 columns.
Please find attached qvf
what is your business logic for SCORE1 and SCORE2 columns?
what is your expected result?
That I highlighted in the image in total column as 'O' and 'X'
yes I see but what's the logic behind that results ?
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'