Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

To fetch only one record in straight table

Hi,

Below is the source data i have .

iditemcheck
1ABCY
2DEFY
3DEFN
4GHIN
5JKLN
6MNON
7MNON
8PQRY
9PQRN
10PQR

N

I need output as

itemcheck
ABCY
DEFY
GHIN
JKLN
MNON
MNON
PQRY

As the above fields are  from different table ,can this be achievable in front end expression in straight table.

Thanks,

Anjee

Tags (1)
3 Replies
Highlighted
MVP
MVP

Re: To fetch only one record in straight table

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

Highlighted

Re: To fetch only one record in straight table

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Not applicable

Re: To fetch only one record in straight table

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.