Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
n1ef5ng1
Creator
Creator

Custom User Panel?

Is it possible to have a custom selection for user panel for QV?

Example

I have this field call WorldWide_Port

Each particular country have many port ie, China will have many port that starts with CN_ _ _ , USA will be US _ _ _

Therefore, to call a particular country, i have to use worldwide_port = 'CN* for a selection.

There are 26 selection for this report.

Is there a way ( a button, variable or something) that I can use to tell QV that this button activate this code call worldwide_port == CN* etc? thanks

2 Replies
n1ef5ng1
Creator
Creator
Author

how about list box?

Anonymous
Not applicable

Using a list box you can make an association in the datamodel, such as when you select Country then only ports for that country are filtered. This seems like the obvious way to proceed. If you are concerned that the list box does not seem enough like a button, then you can create 26 list boxes, each with an expression that says something like:

     =if([Country]='China',Country)

This will allow you to output the countries one at a time and you can then add rounding on the Layout properties and remove the Caption on the Caption properties etc.

If you do not want to filter the data for each country, you can set up a variable that says which country you want to look at and then change all your expressions to include this variable, in the format $(vSelectedCounty).

A third option is to use Alternate States which allow you to make preselections of State Identifier that your charts then display. See section 14.4 in the QV v11 manual.

Jonathan