topic Re: To fetch only one record in straight table in QlikView

To fetch only one record in straight table

veeranj — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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.

Thanks,

Anjee

tresB — Thu, 22 Dec 2016 08:40:25 GMT

If you want to show unique records only, you can simply use a table box with those fields.

Anil_Babu_Samineni — Thu, 22 Dec 2016 08:50:56 GMT

What was the logic behind for duplicate items and getting check value.

Thu, 22 Dec 2016 08:55:44 GMT

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.