topic First value for specific id with multiple same values in QlikView

First value for specific id with multiple same values

v_ganchev — Sat, 16 Nov 2024 20:56:26 GMT

Hello.
Here is the scenario.

ID	Value
1	Value Text
1	Value Text
1	Value Text
1	Not Wanted Value Text

The question is how to see like this table:

ID	Value
1	Value Text

Always there is a multiple the same ID.
Every single ID have multiple values, only the last value is different.
I need to get only Value Text, which is text.
The last value is text that I don't need.

Re: First value for specific id with multiple same values

sunny_talwar — Fri, 03 May 2019 12:59:17 GMT

So, you want to do this in the script and you only want a single row with the value text which is not associated with the last row?

Re: First value for specific id with multiple same values

v_ganchev — Wed, 08 May 2019 08:38:15 GMT

Yes. I was trying from the table chart but didn't success.

Re: First value for specific id with multiple same values

Gabriel — Wed, 08 May 2019 09:00:23 GMT

Hi,

My question is, would you always know the value you wish to exclude?

If the answer is yes, then in your UI you can exclude the value using

COUNT({<Value -={'Not Wanted Value Text'}>} ID)

And in script use

tmp:
LOAD * INLINE [
ID, Value
1, Value Text
1, Value Text
1, Value Text
1, Not Wanted Value Text
](delimiter is ',')
WHERE NOT MATCH(Value,'Not Wanted Value Text');

Let us know if this helps

Re: First value for specific id with multiple same values

sultanam — Wed, 08 May 2019 09:34:02 GMT

Hi,

If you only want to load first value then use below code

LOAD ID,
firstvalue(Value) as Value
FROM
Source group by ID;

Regards,
Sultan