Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ShellyG
Creator
Creator

Question about a table field

Hi everyone, 

Can someone give me an advise what to do in the following situation:

I have a field that shows how fast a ticket was resolved. So basically this field contains - "same day", "more than 2 days", "more than a week", "more than a month", etc. 

I need to visualize this by only showing - "same day" and "not the same day". 

How can I do that on a script level while also keeping the field in its original state? 

Thanks! 

 

Labels (2)
1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

so load your field as a second one

load

yourfields,

if(solved='same day',same day','not the same day')) as Newsolved

from Yoursource;

Regards

View solution in original post

2 Replies
martinpohl
Partner - Master
Partner - Master

so load your field as a second one

load

yourfields,

if(solved='same day',same day','not the same day')) as Newsolved

from Yoursource;

Regards

ShellyG
Creator
Creator
Author

Thanks a lot!