Filter in combination with a predefined list of words

[Anonymous]

Hi guys,

I'm desperately trying to combine a filter with a pre-defined list of words from an Excel sheet. It's supposed to work like this:

Filter:                                                      List of recommendations:

a                                                                          Do this and that

Right now I realized this with a filter and a table which does not look professional at all. From my Point of view there is no nice way of doing this. Any recommendations how to present this with Qlik Sense?

Cheers in advance!

[albert_guito]

Hi,

Maybe insted of a Table using a text object with a Only() expression to show only one recommendation
If you have the last version of QllikSense you can use the function "Always one selected value" in you filter pane

Ag+

[Anonymous]

Hey AG,

thanks for your quick response. Actually that works indeed but just for one recommendation. Nevertheless in my list there are also sometime 2 or even 3 recommendations. How can I adapt it?

Filter                                         Recommendations

a                                                           Do Plan A

                                                             Do Plan B

Cheers! 🙂

[santoshknc]

Hi,

Cant you utilize the Match and/or Pick functions along with these filters to work ? If your utilizing this across multiple locations, you can defined them as a variable or Master Dimension.

Thanks,

Santosh

[albert_guito]

If Text object is a good solution you can use a Concat function for multiple responses.

I play with this set of data:

Recommendation:
Load * Inline [recommendation, do
during a fire, do not use elevators
during a fire, be cautious before oppening doors
during a fire, crawl under smoke and leave the build
during an earthquake, stay in calm
during an earthquake, evacuate the build until shaking stopped
];

The Text object use a concat() like this:

=Concat(do,Chr(13))

Ag+

[Anonymous]

Thanks for the Provision of possible solution ways.

Nevertheless I'm still a Greenhorn with Qlik Sense and thus not able to follow your instructions.

For comprehension reasons can you write down the symbolic code so I can understand it and do it on my own as I do not really understand how to implement a Concat function? Would be awesome 🙂

Filter (Dimension=Fun)                              TextBox (Measure= Whatever)

                          a                                                    Do this

                                                                                 Do that

                         b                                                  Do nothing

                                                     and

                                                      so

                                                     on

[Anonymous]

Anyone? Would be really awesome

[albert_guito · Accepted solution]

HI,

I attach a sample with the code for testing

Ag+

[albert_guito]

And a picture with the sample running ...

[Anonymous]

Thanks man! Helped me a lot 🙂

TY!