topic Re: Set Variable to Text Value with an if(then) statement in QlikView

Set Variable to Text Value with an if(then) statement

leale1997 — Thu, 09 Apr 2015 23:12:14 GMT

New to qlik so this is probably a simple fix but I am just missing the solution.

I have a data set with a field called date_closed.

I want to create a variable that will display the text 'Open' anytime that field is null, and 'Closed' if the field is not null.

This is the script I have been trying to use:

SET vRecordStatus =IF(IsNull(date_closed), 'Open', 'Closed') ;

Re: Set Variable to Text Value with an if(then) statement

Anonymous — Thu, 09 Apr 2015 23:22:24 GMT

Hi Erka,

The expression is fine. Just that use LET in place of SET. Your expression would be

LET vRecordStatus =IF(IsNull(date_closed), 'Open', 'Closed') ;

Cheers,

Ritesh Pathak

Re: Set Variable to Text Value with an if(then) statement

leale1997 — Thu, 09 Apr 2015 23:32:49 GMT

Thanks so much! That worked.

Can I bother you with one more question? I want to assign the variable to an input box so that a drop down will appear, allow the user to choose between 'Open' and 'Closed' and change all the records on the page to correspond to the variable selection.

I created an input box and assigned the variable I created. But only the 'Open' is appearing with no option to choose 'Closed'

Re: Set Variable to Text Value with an if(then) statement

Anonymous — Thu, 09 Apr 2015 23:50:12 GMT

Hi Erka,

Please goto variable overview and delete your variable vRecordStatus and then use below expression for your variable creation

LET vRecordStatus = if(IsNull(date_closed) or Trim(date_closed) ='', 'Open','Close') ;

it should work.

Let me know if you face any more issue.

Cheers,
Ritesh Pathak

Re: Set Variable to Text Value with an if(then) statement

Anonymous — Fri, 10 Apr 2015 00:47:36 GMT

Hi Erka,

What you could do is:

While loading the table itself load additional column in your script. See script below for details:

Load

Date_Closed,

if(IsNull(date_closed) or Trim(date_closed) ='', 'Open','Closed') as Status

From ...... ;

and use the new field 'Status' as a list box for filter and in your expression for chart calculation. Hope it should work.

Please confirm whether it worked or not.

Thanks and regards,

Ritesh Pathak