topic Re: Get rid from second expression in list box in QlikView

Get rid from second expression in list box

Anonymous — Thu, 08 Jun 2017 10:48:59 GMT

Hello Everyone,

Can anyone help me in getting rid of the second value from the list box?

I have a list box with Month field but the field is in numeric format. I want in text format.

So, I used =if(Month1=2,'Feb',If(Month1=3,'Mar',if(Month1=4,'Apr','May'))) this formula in expression but getting the result in given in the attachment .

Thanks in advance for the help.

Re: Get rid from second expression in list box

swuehl — Thu, 08 Jun 2017 10:55:45 GMT

Use your expression not in the expression tab of the list box properties, but as calculated field / dimension on general tab (select <expression> from field drop down list and enter your expression).

You can also use something like

=Month(Makedate(2017, Month))

and maybe create a new field in the load script for that.

Re: Get rid from second expression in list box

sunny_talwar — Thu, 08 Jun 2017 10:56:13 GMT

Are you using this on the expression tab or general tab? You need this on the general tab of list box properties

Re: Get rid from second expression in list box

Anonymous — Thu, 08 Jun 2017 11:04:02 GMT

Thanks for Reply Stefan,

But I would like to add that in list box properties I didn't have Dimension or general tab.

I M using list box wherein i used month which is in numeric format.

Re: Get rid from second expression in list box

sunny_talwar — Thu, 08 Jun 2017 11:05:34 GMT

You need to use it here

Re: Get rid from second expression in list box

Anonymous — Thu, 08 Jun 2017 11:06:24 GMT

Thanks Sunny for reply,

In list box where I used this formula.

General Tab? where

Re: Get rid from second expression in list box

Anonymous — Thu, 08 Jun 2017 11:07:46 GMT

Thanks Sunny,

Re: Get rid from second expression in list box

sunny_talwar — Thu, 08 Jun 2017 11:09:53 GMT

No problem....