Discussion board where members can get started with QlikView.
Below is the source data i have .
I need output as
As the above fields are from different table ,can this be achievable in front end expression in straight table.
If you want to show unique records only, you can simply use a table box with those fields.
What was the logic behind for duplicate items and getting check value.
For DEF you have taken only one value 'Y'
and MNO you have both values 'N'.
Do you need first sorted Value or is there any other logic to show values.