Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
On one of our fields called probcode from the table Opencall we have data that looks as below:
Call Ref | Probcode |
---|---|
200300 | RQST - CRPR - M004 - ERR1 - NETW |
200301 | RQST - CRPR - M004 - ERR1 |
200302 | RQST - CRPR - M004 |
The code is linked to a specific description in another table which shows as such:
RQST = Request
CRPR - Corporate Software
M004 - Maximo
ERR1 - Error 1
NETW - Network
In Qlikview we pull these out in specific levels, so RQST is Level_1, CRPR is Level_2, M004 is Level_3, ERR1 is Level_4 and NETW is Level_5
We then have a straight chart, which currently pulls out anything in Level_5. However the issue I have is that as per table above, Call Ref: 200301 and 200302 do not have a level_5 code, they have a level_4 and level_3 code as their last code respectively. Therefore on my straight chart call ref: 203000 shows a Network and 200301 + 200302 shows a NULL.
What I am looking to achieve is in my straight chart can I pull through whatever the last probcode shows. So my straight chart will look as such:
Call Ref | Problem |
---|---|
200300 | Network |
200301 | Error 1 |
200302 | Maximo |
Regards,
Jon Ditchfield
Try this as a expression:
if(not IsNull(Level_5),
Level_5,
if(not IsNull(Level_4),
Level_4,
if(not IsNull(Level_3),
Level_3,
if(not IsNull(Level_2),
Level_2,
Level_1
))))
Try this as a expression:
if(not IsNull(Level_5),
Level_5,
if(not IsNull(Level_4),
Level_4,
if(not IsNull(Level_3),
Level_3,
if(not IsNull(Level_2),
Level_2,
Level_1
))))
Hi
See the attched application