Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
VAR
Contributor
Contributor

Qlikview Multiple Status

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

 

Labels (1)
1 Reply
Qrishna
Master
Master

sample data please?