Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-08-06 07:29 AM

Filter Pane - Defined option list

Hi All

I am currently using QLikSense Web Dashboards to bring in data from a variety of sources, for example on premise SQL and Dynamics CRM Online.

I want to be able to setup a Filter Pane that has a predefined set of value, for example:

  • Country A;
  • Country B;
  • Country C;
  • County D.

I then want to be able to on a chart to be able to filter on what is selected on the Filter Pane.

Is this even possible? And if so how could this be done?

Regards

363 Views
0 Likes
1 Reply
ogster1974
Partner - Master II
Partner - Master II
‎2018-08-06 11:44 AM

Sounds a pretty straight forward request.

You can load your predefined list as an inline statement or from a controlled list i.e. Excel.

Then join the countries on your fact data usually this is some sort of iso code.

328 Views
0 Likes