topic Listbox in QlikView

Listbox

Wed, 29 Jan 2014 13:35:28 GMT

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

Re: Listbox

alexandros17 — Wed, 29 Jan 2014 13:40:05 GMT

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

Re: Listbox

rustyfishbones — Wed, 29 Jan 2014 13:41:22 GMT

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

Re: Listbox

puttemans — Wed, 29 Jan 2014 13:51:37 GMT

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'

Re: Listbox

hic — Wed, 29 Jan 2014 14:11:50 GMT

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

Crosstable (Fruit,Flag) Load ...

HIC