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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
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?