Listbox

[#1]

Hi everyone,

I am looking at combining a few columns into one- so at the moment I have different columns named Apple, Pear, Banana, Grape with a tick if an object fits the description, but I want them to all be a part of the column named Fruit. Any suggestions?

Thank you!

Anna

[alexandros17]

When you load data you need a flag , something like

load

...

if(col1 = 'Apple' or col2 = 'pear' or ..., 'F', 'X') as isFruit

...

When you check data add the condition on flag isFruit = 'F'

Hope it helps

[rustyfishbones]

you need to create a Hierarchy I think and then show the list box as Treeview

[puttemans]

If you did not make too many changes in your document, you could transpose the dataset while reading it into Qlikview.

In you second screen (transform), click on the 'Enable transformation step', take the tab 'rotate', and then push the button 'Transpose'

[hic]

Sounds like a crosstable to me... Look at the "Crosstable" prefix in the help.

Crosstable (Fruit,Flag) Load ...

HIC