Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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):
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:
Regards,
Jaime.
PS: Europe is not a Country 😋
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