Hidden Columns Grouping in Straight Table

[wnorwood]

Hello,

I have a straight table where I have many columns that I hide or display based on a selection from a list box.  However, it appears that the straight table still recognizes the hidden column in that it still groups on it.  Is there some setting to make the chart completely ignore the field if it his hidden? 

I am using QV 10.

Thanks!

[v_iyyappan]

Hi,

Exactly what u need. do u hide the column based on listbox selection or hide the table based on listbox selection.

Any way am attached a sample QV file.

Hope its help for u,

Regards,

Iyyappan

[#3]

When you say 'columns' do you mean dimensions or expressions? Your reference to 'grouping' indicates dimensions. You can create a dynamic table where the user can specify the dimensions via a drop down by writing a maco.

[wnorwood]

Sorry to take so long to reply.  I am trying to hide/show columns within a straight table chart based on a list box selection.  It is dimensions that was giving me trouble I think.

[sivarajs]

goto to presentation tab in chart properties and select the column or expression you want to hide then select conditional and give condition

[#6]

I am seeing the same issue - I want to hide dimension columns and have the chart (straight table) behave as if the dimensions were not there.

For example, I have a 2 dimension chart: Year and Month dimensions. If I hide the Month dimension, the chart still has 12 rows for each year, instead of one row for each year as I want it to do.

Is there a solution to this?

Anyone?

[wnorwood]

I ended up having to write a macro that creates the Straight Table chart on the fly.  That is the only way I could find to work around the problem.

[#8]

Wnorwood,

Would you mind sharing your macro? That sounds like an interesting option.

Tyler Waterfall

Global Inventory Strategy | Lands' End | 608.937.5223 | tyler.waterfall@landsend.com<mailto:tyler.waterfall@landsend.com

[wnorwood]

Here  is the macro.  I had to remove any reference to company specific info, but I tried hard not to take out anything critical to the macro.  Hope this helps!

[#10]

Very nice. Thank you for sharing (and taking the time to modify it to share)!