Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I'm afraid I don't quite understand what you describe. Can you post a qlikview document that demonstrates it?
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 !
I can't reproduce this in QV 11.20. I don't have QV 11.00 SR1 to test.
Thank you for your response