Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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+
Anonymous
Not applicable
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 - Creator
Partner - Creator

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+
Anonymous
Not applicable
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

Anonymous
Not applicable
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+
Anonymous
Not applicable
Author

Thanks man! Helped me a lot 🙂

 

TY!