Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Manuel174102
Creator
Creator

How to not display certain information in a table

Hello Everyone,

I have the following table 

Num Line
1 10000
1 30000
2 20000
2 40000
3 10000
3 50000
3 10000
3 20000
4 10000
4 20000

and I just need this : 

 

Num Line
1 10000
2 30000
3 10000
4 10000

 

I need to only keep the smaller "LINE" for each number. Can I do it in the front end? or should I do it in the back end?

 

Thanks

Labels (1)
10 Replies
BrunPierre
Partner - Master II
Partner - Master II

@Manuel174102  as @Lakshminarayanan_J  suggested you may have to share specific details as to why it doesn't work for you because all the suggestions seem correct.