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

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
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
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-05-22 03:25 AM

Show all values in country Dimension

Hi All,

  Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL  otherwise it should show selected country.

countrySales
ALL40
IND20
USA10
UK10
Labels (1)
Labels
480 Views
0 Likes
1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III
‎2018-05-22 03:47 AM

Rather than adding ALL to the listbox, train your users so that they understand that clearing all selections is the same as selecting ALL.

And if that is a pivot table, check the partial totals option in Chart Properties | Presentation so QV calculates the total.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
406 Views
0 Likes