columns in a straight table to be displayed dynamically

[raghavsurya]

Hi All,

We have a requirement wherein the columns in a straight table chart should be shown only when selected. For example

Revenue QTR 1 QTR2 QTR3 QTR4 YTD

Sales 2500 2800 3200 2500 11000

Services 1500 2500 1500 2500 8000

If I click on QTR1 in list box provided, the table should show only QTR1 and other columns should not be shown, Also if I select 2 values in listbox like say QTR1 and QTR2 , columns for these two quarters should only be shown.

Can somebody help me how to achieve it.

Regards,

Raghav

[brenner_martina]

Hi,

one question, what is your dimension. If you have a timedimension with QTR1, QTR2 and so on, qlikview do your suggestion by its own. in a pivottable you can drag the dimension time shown a title of the columns.

[raghavsurya]

Hi Martina,

The Dimension is Revenue streams. QTR1, QTR2, QTR3 and QTR4 are my expressions.

Regards,

Raghav

[brenner_martina]

Hi Raghav,

then QlikView does it right? Did you define a Pivottable and get the dimension Revenue strem in the top?

[raghavsurya]

Hi Martina,

The user wants to view the table in the way I have mentioned in the post earlier. Only requirement is the expressions should change dynamically based on the selections I make.

Regards,

Raghav