Below is the table and data I am using to illustrate.
Each person with Unique ID have 2 choices.
Only 1 choice will be offered. And each person has to indicate whether to accept the choice allocated to him/her.
What is the expression to count the number of person who have accepted 'Butter, as their choice? (ie Acceptance = 'Yes' and ((1st Choice = 'Butter' and ChoiceOffered = '1st') or (2ndChoice = 'Butter' and ChoiceOffered = '2nd'))
I have created a bar chart for counting butter, apple, orange and bread items for 1stChoice and another bar chart for AllChoices with those items.
And I am creating a "KPI" diagram on top of this bar chart, in Qlik Sense Desktop.
I would like to track count for this "KPI". Whenever an item ( butter, apple, orange and bread) is selected in the bar charts, this KPI will show the number of person who have accepted an item (eg 'Butter'), as their choice.