Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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
Author

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

Kush
MVP
MVP

Hi

See the attched application