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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Group and Ungroup listbox values

Hi,

I have a listbox named as "GEO" with values "NAZ" , "LAS" and "EUZ" .

I want the list box to show all these and also "TOTAL" which will mean the selection of all three.

Is there a way to achieve this ?

Kindly help.

Thanks

Anvita

2 Replies
arulsettu
Master III
Master III

try this

load * inline [

GEO,NEWGEO

NAZ,NAZ

LAS,LAS

EUZ,EUZ

NAZ,TOTAL

LAS,TOTAL

EUZ,TOTAL

];


use NEWGEO in list box

Colin-Albert
Partner - Champion
Partner - Champion

You don't need a TOTAL option in a listbox as in QlikView, selecting nothing in a listbox selects all possible values in that field.

This is shown by the fact that the fields are white when unselected showing they are included in the current selection and are not grey (excluded).

Qlik Tips: Raise a flag to the Green, White and Gray