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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
varma8998
Contributor III
Contributor III

Simple list function

Hi Folks,

I have a field name called Country in that we have Germany, france, Europe, and soon

The question is I want to add ALL in the Filed Country

ALL is the total of country

now what ever we filter from field according to that the values should populate

I have tried the below function,

dim:

Load * Inline

[

dim

1

2];

and in the list box I used if(dim =1 , country, 'All')

is there any way to add 'ALL' in the simple list function because the above method I am getting error

Please help me with that

2 Replies
jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

What do you mean by "list function"? I can interpret it in two different ways:

1) In a table, you need a total ("ALL") row. It is automatic for straight table (you'll have to change "total label" in Presentation tab):

solve.png

2) you need a Filter Pane for Country and you need to select ALL. I don't see a need here sin selecting nothing is almost equivalent to selecting all values. If you need to select all values, you dont need a "ALL" field value, just write an asterisk in the search field and then press enter:

solve.png

Regards,

Jaime.

PS: Europe is not a Country 😋

varma8998
Contributor III
Contributor III
Author

in Qlik sense we have extension called Simple list function, there we can select default filter. in the normal filter pane which was provided default there as you said we no need to add any thing .

In the simple list extension there this is not working we have write some code to add the any value in the field