topic Re: Hidden Columns Grouping in Straight Table in QlikView

Hidden Columns Grouping in Straight Table

wnorwood — Tue, 17 Apr 2012 15:32:46 GMT

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!

Re: Hidden Columns Grouping in Straight Table

v_iyyappan — Tue, 17 Apr 2012 16:52:22 GMT

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

Re: Hidden Columns Grouping in Straight Table

Tue, 17 Apr 2012 21:10:03 GMT

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.

Hidden Columns Grouping in Straight Table

wnorwood — Fri, 20 Apr 2012 19:47:39 GMT

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.

Re: Hidden Columns Grouping in Straight Table

sivarajs — Sat, 21 Apr 2012 09:07:39 GMT

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

Re: Hidden Columns Grouping in Straight Table

Wed, 16 May 2012 15:47:02 GMT

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?

Hidden Columns Grouping in Straight Table

wnorwood — Wed, 16 May 2012 16:07:27 GMT

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.

Re: Hidden Columns Grouping in Straight Table

Wed, 16 May 2012 16:28:45 GMT

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

Re: Hidden Columns Grouping in Straight Table

wnorwood — Wed, 16 May 2012 17:35:02 GMT

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!

Re: Hidden Columns Grouping in Straight Table

Wed, 16 May 2012 18:14:34 GMT

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