Adding in last text on Straight Table

Thu, 01 Aug 2013 11:25:38 GMT

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

Re: Adding in last text on Straight Table

Thu, 01 Aug 2013 11:42:51 GMT

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

Re: Adding in last text on Straight Table

Kushal_Chawda — Thu, 01 Aug 2013 12:06:08 GMT

See the attched application

topic Adding in last text on Straight Table in QlikView

Adding in last text on Straight Table

Re: Adding in last text on Straight Table

Re: Adding in last text on Straight Table