Dynamic Columns - values from table via input box?

Mon, 01 Jul 2013 14:54:49 GMT

Hi,

I got a case wherewe need to lets users build their own customize rapport where they can compare the values.

Lets say I build a table where I'll put day (column 1) .

Then I need to create dynamic cuztomized columns lets say where users should be able to decide them selves what to choose: i.e.

1 column for Articles (Books, Music, Movies)

4 of the same type of columns with dropdown box/menu for Countries (Denmark, Norway, Sweden, Island, Germany, France, Italy, Spain)

the point is that the users can choose lets say:

Books and then to se the prices for comperision in the 4 different countries of their choosing in the next 4 collumns next to each other. lets say Denmark against Island against Italy against Sweden.

How would it be possible to build that table?

Re: Dynamic Columns - values from table via input box?

Gysbert_Wassenaar — Tue, 02 Jul 2013 18:49:23 GMT

If you have QV11 you can use conditional expressions for Dimensions. See attached example. The items to show are selected in listboxes. Multiboxes works as well. But dropdown boxes in the pivot table itself won't work.

topic Re: Dynamic Columns - values from table via input box? in QlikView

Dynamic Columns - values from table via input box?

Re: Dynamic Columns - values from table via input box?