Adding in last text on Straight Table

[#1]

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

[#2 · Accepted solution]

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
))))

[Kushal_Chawda]

Hi

See the attched application