Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Partner

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
Partner

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

ShellyG
Creator
Creator
Author

Thanks a lot!