topic Re: show rows based on column in QlikView

show rows based on column

rafael5958 — Sat, 16 Nov 2024 00:04:37 GMT

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:

name	value	type
AAAA	XXXX	1
AAAA	XXXX	3
AAAA	BBBB	4
FFFFF	GGGGG	2
FFFFF	GGGGG	3
XXXXX	FFFFFF	3

and need this:

name	value	type
AAAA	XXXX	1
AAAA	BBBB	4
FFFFF	GGGGG	2
XXXXX	FFFFFF	3

Re: show rows based on column

lironbaram — Wed, 26 Aug 2020 12:38:40 GMT

build a table

use : name and value as dimensions

and min(type) as expression

Re: show rows based on column

Kushal_Chawda — Wed, 26 Aug 2020 12:40:00 GMT

try below

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

Re: show rows based on column

Taoufiq_Zarra — Wed, 26 Aug 2020 12:43:23 GMT

if i understood correctly

Dimension: name and value

Measure : min(type)

output :

if not can you elaborate ?

Re: show rows based on column

Brett_Bleess — Tue, 08 Sep 2020 19:02:07 GMT

@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