Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Adding in last text on Straight Table

Hi,

On one of our fields called probcode from the table Opencall we have data that looks as below:

Call RefProbcode
200300RQST - CRPR - M004 - ERR1 - NETW
200301RQST - CRPR - M004 - ERR1
200302RQST - 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 RefProblem
200300Network
200301Error 1
200302Maximo

Regards,

Jon Ditchfield

1 Solution

Accepted Solutions
Not applicable

Re: Adding in last text on Straight Table

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

))))






View solution in original post

2 Replies
Not applicable

Re: Adding in last text on Straight Table

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

))))






View solution in original post

Re: Adding in last text on Straight Table

Hi

See the attched application