topic Re: Selection based on calculated field in QlikView

Selection based on calculated field

Thu, 26 Apr 2012 08:17:30 GMT

Hi,

In the attached QVW I have a calculated field called "Delivery Status". The value can either be "Open" or "Closed". I would like to create a list box where I can select based on this calculated value.

E.g. show me the "Contnr ID" that are "Open".

Any suggestions?

Br. Jakob

Re: Selection based on calculated field

Thu, 26 Apr 2012 08:28:28 GMT

Hi,

it's maybe this what you're looking for ?

See attached file

Hope it helps

Giampiero

Selection based on calculated field

Thu, 26 Apr 2012 08:48:17 GMT

Hi Giampiero,

Unfortunately not. I need a list box containing the values "Open" and "Closed". When selecting "Open" all "Contnr ID" with the calculated value "Open" shall be shown.

Re: Selection based on calculated field

Miguel_Angel_Baeyens — Thu, 26 Apr 2012 09:06:10 GMT

Hi Jakob,

Create a new listbox with the following expression in it (select <Expression> from the Field dropdown at the very bottom)

=Aggr(if(MaxString(ExtractDate) < Today(), 'Closed', 'Open'), [Contnr ID])

Hope that helps.

Miguel

Selection based on calculated field

Thu, 26 Apr 2012 09:13:10 GMT

Thanks. Exactly what I was looking for.

Re: Selection based on calculated field

IAMDV — Thu, 26 Apr 2012 11:27:17 GMT

Hi Miguel,

Hope you’re doing well. I like your solution, thank you.

Taking this a step further, how do I assign dynamic ListBox with“Always One Selected Property”? I’m not sure if this is possible...

Thanks,

www.QlikShare.com

Re: Selection based on calculated field

Thu, 26 Apr 2012 14:53:36 GMT

Hey Jakob-

Like you, I am trying to specify whether an item is one thing or another. In my environment, I must categorize orders into one of six "buckets" based on their order size. I have pasted in the AGGR function that you were given by Miguel and started with only two of the buckets: <$1,000 and >$1,000. The results in my List Box are not working correctly.

Is it possible for you to repost your .qvw norw that it is working or at least post the expression from your List Box Properties?

I am using v10 if that matters.

Kevin

Selection based on calculated field

Miguel_Angel_Baeyens — Thu, 26 Apr 2012 15:25:28 GMT

Hi DV,

I don't know if that's a bug or a WAD, but the thing is that when using expressions (or key fields) always onve value selected is not possible. It does some sense to me in the case of key fields, because of linking tables and unexpected behavior, though.

You should open a Support case so they can guide you further.

Hope that helps.

Miguel

Re: Selection based on calculated field

Fri, 27 Apr 2012 07:19:19 GMT

Hi Kevin

Attached is the file. Hope it can help you.

BR. Jakob