topic Dropdown select dimension on cross tab issue in QlikView

Dropdown select dimension on cross tab issue

Wed, 05 Aug 2015 07:04:09 GMT

Hi all,

We have an issue with dropdown selection on dimension in a pivot table.

I don't known if it's in our version or not, we are using version 11.0011282.0 SR1 64-bit.

We have a pivot table with several pick dimensions (account, item, month and year with conditional display on account and item) and 2 expressions (sum of sales, count of orders). Month is display horizontally and year vertically

When the first dimension is picked the dropdown selection is ok, we can select our accounts.

But if we unselect the account dimension and we select the item dimension the dropdown selection show still the account selection we are unable to select item.

The pivot table dropdown selection doesn't change on dimension conditional display.

I wonder if the problem is known.

Thank you in advance for your feedback.

Re: Dropdown select dimension on cross tab issue

Gysbert_Wassenaar — Wed, 05 Aug 2015 15:38:58 GMT

I'm afraid I don't quite understand what you describe. Can you post a qlikview document that demonstrates it?

Re: Dropdown select dimension on cross tab issue

Wed, 05 Aug 2015 15:55:34 GMT

Hi Gysbert and thank you for your response.

Please find an example with conditionnal dimension and dropdwon selection in a pivot table.

I have select customer country and customer phone in dimension, in the pivot table if you try to dropdown the selection on customer country you don't have the list of customer country but the list of customer.

if you try to dropdown the selection on customer phone you don't have the list of customer phone but the list of customer country.

Qlikview doesn't display the correct filter when you use conditional dimension in a pivot table.

Thank you in advance for your help !

Re: Dropdown select dimension on cross tab issue

Gysbert_Wassenaar — Wed, 05 Aug 2015 16:12:42 GMT

I can't reproduce this in QV 11.20. I don't have QV 11.00 SR1 to test.

Re: Dropdown select dimension on cross tab issue

Thu, 06 Aug 2015 06:25:51 GMT

Thank you for your response