Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unwanted selection when using expression in Multi Box

I have a problem when filtering my Multi Box to only show the dates for which I have data in a specific field. The expression I am using is this:

=if( not IsNull([Värde SO-historik]), Datum )

The result is what I want - now only the relevant dates are shown:

Multi Box.jpg

However, when selecting a date I also get a selection in the field I used in the above condition:

Selected.jpg

This is undesirable. How can I make it so that no selection is made in the field "Värde SO-historik"?

3 Replies
swuehl
MVP
MVP

The easiest way would be to create another field with the same filter in your data model, then use this field in the multi-box.

Not applicable
Author

Hi, thanks for the prompt answer!

This is actually how I have currently solved it, but I wanted to use the field "datum" so that a selection here will be meaningful also for other tabs and charts in my app (it is quite big with 9 tabs - one for each KPI - and the specified field should optimally be relevant for all the tabs).

swuehl
MVP
MVP

Try something like

=aggr( if( not only({1} IsNull([Värde SO-historik])), only({1}Datum) ), Datum)