Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
m_fleischmann
Contributor III
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!

1 Solution

Accepted Solutions
albert_guito
Creator II
Creator II

HI,

I attach a sample with the code for testing

 

Ag+

Ag+

View solution in original post

9 Replies
albert_guito
Creator II
Creator II

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+
m_fleischmann
Contributor III
Contributor III
Author

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
Partner
Partner

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

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

Anyone? Would be really awesome

albert_guito
Creator II
Creator II

HI,

I attach a sample with the code for testing

 

Ag+

Ag+
albert_guito
Creator II
Creator II

And a picture with the sample running ...

Ag+
m_fleischmann
Contributor III
Contributor III
Author

Thanks man! Helped me a lot 🙂

 

TY!