topic Re: List box - either/or selections? in QlikView

List box - either/or selections?

Thu, 07 Jan 2016 16:49:31 GMT

Hi QlikView gurus - this is probably a simple question.

I have a list box:

I need an option where either "All Lines" can be checked, or any other combination of lines, but not both at the same time. Right now, it's working like this:

This returns very bad data.

Thank you in advance for your help!

Re: List box - either/or selections?

sinanozdemir — Thu, 07 Jan 2016 17:27:55 GMT

Hi,

I might have misunderstood your requirements, but here is what I have:

You are hiding all other selections and the exp is:

Let me know if this is what you are looking for.

Thanks

Re: List box - either/or selections?

Thu, 07 Jan 2016 18:04:39 GMT

Thanks, but that wasn't quite working for what I need. I think I need and either / or function so that "All lines" can't be chosen at the same time as any of the other lines, but any combination of other lines can be chosen. "All Lines" is a sum total of the other lines, so if it is chosen along with other lines it returns redundant data.

Re: List box - either/or selections?

maxgro — Thu, 07 Jan 2016 19:17:09 GMT

try to add a trigger on your field (on select)

Actions --> Select in field

Field -->Line

Search String

='(' &

if(Alt(SubStringCount(GetFieldSelections(Line, '-'), 'All lines'), 0)

,chr(34) & 'All lines' & chr(34),

chr(34) & GetFieldSelections( Line, chr(34) & '|' & chr(34) ) & chr(34)

)

& ')'

When you select "All lines" or "All lines" and something else the trigger will select "All lines"

Re: List box - either/or selections?

Thu, 07 Jan 2016 20:48:58 GMT

Thank you, but that's not working either. I attached the qvw below. It's the same issue with the "Metric" list box. If "Overall DT %" is chosen, user shouldn't be able to make other selections at the same time.

Re: List box - either/or selections?

sinanozdemir — Thu, 07 Jan 2016 21:54:46 GMT

Hi,

Can you take a look at it now?

Thanks

Re: List box - either/or selections?

Thu, 07 Jan 2016 22:50:50 GMT

That works great. Thank you!!!

Re: List box - either/or selections?

sinanozdemir — Thu, 07 Jan 2016 23:25:39 GMT

You are welcome.

Re: List box - either/or selections?

mohan2391 — Fri, 08 Jan 2016 13:17:13 GMT

Hi,

Could you explain the process here. I have personal edition only, can't open your QVW.

Re: List box - either/or selections?

Fri, 08 Jan 2016 19:04:48 GMT

Expression is =If(GetFieldSelections(Line) = 'All Lines', Aggr(Line, Line), Line)