topic Re: Enable Condition on Dimensions Shifting Columns in QlikView

Enable Condition on Dimensions Shifting Columns

john_duffy — Mon, 23 Jun 2014 15:10:54 GMT

Hello All.

I have a requirement to create a straight table with the following criteria.

All dimensions have the Enable Condition selected.

Some dimensions are to located to the right of some expressions.

The enable/disable of dimesions works fine.

The chart displays in the correct format when all dimensions are selected.

The issue occurs when one or more dimensions are disabled. The dimensions shift to the left.

I have attached a very simple example to illustrate the issue. When all dimensions are selected, Contact is displayed between Total Sales and Yearly Sales. If I deslect Location, Contact shifts to the left of Total Sales. I want it to stay between Total Sales and Yearly Sales.

Any help would be greatly appreciated.

Thanks,

John.

Re: Enable Condition on Dimensions Shifting Columns

maxgro — Mon, 23 Jun 2014 18:06:56 GMT

? attachment is missing

Re: Enable Condition on Dimensions Shifting Columns

rwunderlich — Mon, 23 Jun 2014 18:53:56 GMT

It appears that chart display column order is based on ordinal position of enabled dimensions. The 2nd dimension is positioned to the left of Total Sales. When you disable Location, Contact becomes the "2nd" dimension.

The only workaround I can think of is to swap in blank columns as placeholders for disabled columns,

-Rob

Re: Enable Condition on Dimensions Shifting Columns

john_duffy — Mon, 23 Jun 2014 19:14:15 GMT

Thanks Rob.

In your opinion, do you think this is a bug?

Re: Enable Condition on Dimensions Shifting Columns

rwunderlich — Tue, 24 Jun 2014 03:46:52 GMT

I would not consider it a bug unless it conflicts with published doc. Just a design decision. You could lobby to have it changed, but that may be disagreeable to people who rely on the current behavior. I think your best bet would be to implement the dummy columns.

Rob

Re: Enable Condition on Dimensions Shifting Columns

john_duffy — Tue, 24 Jun 2014 12:57:31 GMT

Thanks Rob. As always, I appeciate you help.