Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion
Champion

Block certain selections when they wouldn't make sense?


Hi,

I have a diagram showing both statical and dynamical data rgd. our staff (the view can be switched via a button).

In a multibox, the user can make selections on several fields.

- The thing is, the statical data (nr. of emps, percentage male/female) can be displayed per area

<=> Dynamic data (starters, leavers) can not because currently the processing of the data in the script would filter out that info if any
       specific area were selected.

=> Can I somehow set the multibox to display certain fields for selection only when a variable (governed by the button) has one value and not the other?`

Thanks a lot!

Best regards,

DataNibbler

4 Replies
Highlighted

Re: Block certain selections when they wouldn't make sense?

Sure you can (see attached).

Highlighted
Champion
Champion

Re: Block certain selections when they wouldn't make sense?

Hi Nicole,

thanks a lot! That's pretty much what I'm looking for - only in my instance, the selection_fields would be dependent on a variable that's actually governing the chart (a binary variable, being 1 or -1 - that makes it easier for buttons)

Can I upgrade that a little so that

- there are two fields for selection when the variable has the value, say, 1

- there is only one (out of those two) field for selection when it has the other value (-1)

Best regards,

DataNibbler

Highlighted

Re: Re: Block certain selections when they wouldn't make sense?

See attached (explanations are in the .qvw).

Highlighted
Champion
Champion

Re: Re: Block certain selections when they wouldn't make sense?


Hi Nicole,

thanks a lot!

You use two separate multiboxes in your example? Good idea.

Best regards,

DataNibbler