topic Qlikview to keep record based on second field in App Development

Qlikview to keep record based on second field

DestinedTale — Fri, 15 Nov 2024 21:50:58 GMT

Hi, I encounter an issue where below will display two records, one duplicate as the max(money) has two identical data.

How do I keep data based on the MAX_LOVE on two records where MAX_LOVE value is higher.

A
load
YearMonth,
Id,
Max(MONEY)as MAX_MONEY

NoConcatenate
A:
load
YearMonth,
Id,
MAX_MONEY &' , '& MAX_LOVE as RICHEST

Chanty4u — Thu, 04 May 2023 02:52:56 GMT

Try this

LOAD

YearMonth,

Id,

MAX(MONEY) as MAX_MONEY,

MAX(LOVE) as MAX_LOVE

RESIDENT <table_name>

GROUP BY YearMonth, Id;

LOAD

YearMonth,

Id,

FIRSTSORTEDVALUE(RICHEST, -MAX_MONEY, -MAX_LOVE) as RICHEST

RESIDENT A

GROUP BY YearMonth, Id;