Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

m_fleischmann
New Contributor III

Filter in combination with a predefined list of words

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!

Tags (2)
1 Solution

Accepted Solutions
albert_guito
Contributor II

Re: Filter in combination with a predefined list of words

HI,

I attach a sample with the code for testing

 

Ag+

Ag+
9 Replies
albert_guito
Contributor II

Re: Filter in combination with a predefined list of words

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+
Ag+
Highlighted
m_fleischmann
New Contributor III

Re: Filter in combination with a predefined list of words

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! 🙂

Partner
Partner

Re: Filter in combination with a predefined list of words

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
Contributor II

Re: Filter in combination with a predefined list of words

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+

 

Ag+
m_fleischmann
New Contributor III

Re: Filter in combination with a predefined list of words

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

m_fleischmann
New Contributor III

Re: Filter in combination with a predefined list of words

Anyone? Would be really awesome

albert_guito
Contributor II

Re: Filter in combination with a predefined list of words

HI,

I attach a sample with the code for testing

 

Ag+

Ag+
albert_guito
Contributor II

Re: Filter in combination with a predefined list of words

And a picture with the sample running ...

Ag+
m_fleischmann
New Contributor III

Re: Filter in combination with a predefined list of words

Thanks man! Helped me a lot 🙂

 

TY!