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: 
simondachstr
Luminary Alumni
Luminary Alumni

How to convert digital data information into a string upon loading

Hey,

I have a data set which solely consists of 0 and 1. On loading, I want those numbers to be converted into string information: 0 = High and 1 = Low
It should go into the following direction:

LOAD

     DATA

     if ( DATA = 0, "High", DATA) OR if( DATA= 1, "Low", DATA) as NewDATA

I would appreciate your help.

Martin

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

use the following:

If(DATA = 0, 'High', 'Low') As NewDATA

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

use the following:

If(DATA = 0, 'High', 'Low') As NewDATA

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein