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!
Solved! Go to Solution.
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?
a Do Plan A
Do Plan B
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.
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:
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
b Do nothing