Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Show alternative values

Hi everybody,

I have a list of locations in a chart and I would like to show the unselected values in a table near it.

How could I do this?

Thanks for your help and for your attention

Best regards

Nicolò Cogno

Tags (1)
1 Solution

Accepted Solutions
hector_munoz_in
Valued Contributor

Re: Show alternative values

Sorry,

I attach a Sense sample:

27-01-2017 16-55-52.png

Regards,

H

8 Replies
hector_munoz_in
Valued Contributor

Re: Show alternative values

Hi Nicolò,

Try the attached sample:

27-01-2017 16-29-25.png

I hope it is useful.

Regards,
H

Not applicable

Re: Show alternative values

Hi Hèctor and thanks for your help, but I posted into the "Qlik Sense" section!! Could you please show me the Sense way of doing that?

hector_munoz_in
Valued Contributor

Re: Show alternative values

Sorry,

I attach a Sense sample:

27-01-2017 16-55-52.png

Regards,

H

Not applicable

Re: Show alternative values

Thanks a lot for your help

mov
Esteemed Contributor III

Re: Show alternative values

Another solution is a list box with expression (in place of field):

=aggr(only({1-$} Location), Location)

Not applicable

Re: Show alternative values

Hi Michael,

I tried everyrhing but I can't understand why your expression doesn't work I can olny see a ' - '.

Can you please help me solving this?

Thanks a lot!

mov
Esteemed Contributor III

Re: Show alternative values

I did test it before sending to you, and just tested again.  It works.  Make sure that the field name is correct.

Besides, make sure you make some selections in the field itself to get that least of the excluded values in the calculated list box.

Not applicable

Re: Show alternative values

Thanks for your time Michael, I will try again! Do I just need to create a dimension with that expression or do I also need to put something into the load script?

My field only contains strings and not numbers!

Could you please attach an example file? Thanks a lot!!!

EDIT: I apologize, but I was using the expression in a table beacuse I thought it worked the same way as the listbox.

So here's my last question: can I use the expression in a chart?

Thanks again for your time