Filter in combination with a predefined list of words
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?
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
If Text object is a good solution you can use a Concat function for multiple responses.
I play with this set of data:
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