Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sample data please?