Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rafael5958
Creator
Creator

show rows based on column

Hi, I want to show rows based in one column, if the row is the same as other, but just change becouse of one column value, keeps the greater lower value. I have a straight table:

namevaluetype
AAAAXXXX1
AAAAXXXX3
AAAABBBB4
FFFFFGGGGG2
FFFFFGGGGG3
XXXXXFFFFFF3

 

and need this:

namevaluetype
AAAAXXXX1
AAAABBBB4
FFFFFGGGGG2
XXXXXFFFFFF3

 

Labels (1)
1 Solution

Accepted Solutions
Taoufiq_Zarra
Master II
Master II

if i understood correctly

Dimension: name and value

Measure : min(type)

 

output :

Capture.PNG

if not can you elaborate ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

4 Replies
lironbaram
Partner
Partner

build a table 

use : name and value as dimensions 

and min(type) as expression 

Kush
MVP
MVP

try below

Load name,
     value,
     min(Type) as Type
FROM table
group by name,value;
Taoufiq_Zarra
Master II
Master II

if i understood correctly

Dimension: name and value

Measure : min(type)

 

output :

Capture.PNG

if not can you elaborate ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Brett_Bleess
Support (Former)
Support (Former)

@rafael5958 You have received multiple replies, we would appreciate it if you would return to the thread to close it out by using the Accept as Solution button on the post(s) that helped you resolve things.  If you need further help, please be sure to leave an update on what you still need, and if you did something different, you can post what you did and then mark that post using the button as well, but I would in that case use the Like feature on any other posts that did help you with things.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.