Qlikview Multiple Status

VAR — Fri, 18 Oct 2024 06:20:31 GMT

Hi, I want to ask about the use of expressions in qlikview :
➢ If there are only 2 consumers in the BPKB number for comparison, then the process is:
▪ If one of the BPKB status accounts is "released" then the result sheet is "OK"
▪ If 2 accounts have BPKB status "New Data, In Progress, Borrowed" then the information sheet
the result is "WARNING"
➢ If the comparison BPKB number is > 2 consumers only, then the process is:
▪ If > 1 account has BPKB status "released" then the result sheet is "OK"
▪ If 1 account's BPKB status is "released" then the results statement sheet
“WARNING”

And im using expression :
=if(aggr(count(DISTINCT RekPin), NoBPKB) <= 2,
if(aggr(sum(if(Status = 'Released', 1, 0)), NoBPKB) > 0, 'OK', 'WARNING'),
if(aggr(count(DISTINCT RekPin), NoBPKB) > 2,
if(aggr(sum(if(Status = 'Released', 1, 0)), NoBPKB) > 1, 'OK',
if(aggr(sum(if(Status = 'Released', 1, 0)), NoBPKB) = 1, 'WARNING', 'WARNING'))))

However, the result is that only 1 account is displayed and the 'OK' statement should have 2 accounts with the same NoBPKB and OK value

Re: Qlikview Multiple Status

Qrishna — Fri, 18 Oct 2024 18:49:05 GMT

sample data please?

topic Qlikview Multiple Status in App Development

Qlikview Multiple Status

Re: Qlikview Multiple Status