topic Re: Remove - in expression in QlikView

Remove - in expression

Wed, 12 Nov 2014 10:51:47 GMT

The following is from a hierarchy. I have added a drop list object to my app and have created concatenate expression on the LocalServiceLine and Specialty field. However, I do not want to include any specialty with '-'. How can i do this.

Re: Remove - in expression

ashfaq_haseeb — Wed, 12 Nov 2014 10:55:01 GMT

Try this in backend.

Load *

From table where len(speciality)>0;

Regards

ASHFAQ

Re: Remove - in expression

Wed, 12 Nov 2014 10:57:59 GMT

I need to include that that as its using the hierarchy method.

Re: Remove - in expression

vardhancse — Wed, 12 Nov 2014 11:03:13 GMT

So you are trying to exclude null values is that correct ?

Re: Remove - in expression

Wed, 12 Nov 2014 11:08:10 GMT

yeas in this example

Re: Remove - in expression

ali_hijazi — Wed, 12 Nov 2014 11:13:16 GMT

in your expression in set analysis use {<Specialty = {"*"}>}

Re: Remove - in expression

vardhancse — Wed, 12 Nov 2014 11:15:10 GMT

Then once can try in chart properties->Dimensions<tab>->select the required dimension->Suppress when value is null

Re: Remove - in expression

Wed, 12 Nov 2014 11:18:15 GMT

I am using a list box object so no option for that.

Re: Remove - in expression

alkesh_sharma — Wed, 12 Nov 2014 11:24:54 GMT

Use where expression during load.

Where Specialty <> '';

Re: Remove - in expression

Thu, 13 Nov 2014 09:03:16 GMT

Like I said I do not want to loose the null in the load script. How can i do this in the expression in the object. My expression in the list object is: = LocalServiceLine & ': ' & Specialty

Re: Remove - in expression

tresB — Thu, 13 Nov 2014 09:08:11 GMT

Try like:

if(Len(Trim(Specialty))>0, LocalServiceLine & ': ' & Specialty)

Re: Remove - in expression

Thu, 13 Nov 2014 09:11:53 GMT

unfortunately that then returns 0 and 1 in the display.

Re: Remove - in expression

tresB — Thu, 13 Nov 2014 09:17:21 GMT

Could you share a qvw with your sample data?

Re: Remove - in expression

umerikhlas — Thu, 13 Nov 2014 10:46:26 GMT

Modify your expression in listbox expression as follows:

If Specialty having null values then this:

=if(not isnull(Specialty), LocalServiceLine & ': ' & Specialty)

If Specialty having values equal to '-' (dashes) then this:

=if(Specialty <> '-', LocalServiceLine & ': ' & Specialty)

Hope this will help you.

Regards,

Re: Remove - in expression

Fri, 14 Nov 2014 12:20:11 GMT

thanks UI that has worked.