Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
amanjain57
Creator II
Creator II

Filter pane not showing values

Hi,

I am using a pivot table with some dimensions and measures.

Dimension: Product Family, Customer etc.

Measure: its just calculation Sum (Revenue)

for Customer i used a expression : Dual(Customer, Aggr(Sum(Revenue),ProductFamily,Customer))

Error 1.JPG

It should show me FORD, GM etc. as shown in the pivot table.

But it is not showing this.

Can someone please help ??

Labels (1)
4 Replies
sunny_talwar

I think there is an issue with calculated dimension and filter pane collapsed. If you extend the size of the filter, you will see the values, but when it is collapsed, the drop down doesn't show values.

amanjain57
Creator II
Creator II
Author

Hi Sunny,

Actually the calculated Dimension works perfectly. In the pivot table i could see that the measure and dimesions are showing up.

Its just that when i go to select the Dimension as shown on the top left hand side of the pivot table.

I do not see any value.

As you could see in the image attached earlier the customers are Ford and GM. it should show up.

Extending the size of filter doesnot helps here.

sunny_talwar

That's what I sort of mean. Its a bug and not sure if they have resolved this yet

amanjain57
Creator II
Creator II
Author

Oh

Sunny can you take a look at this thread : Sorting within a dimension in a pivot table.

Actually i was trying to solve this piece when the error mentioned in this post appeared.

I was suggested a solution here and it works, but the limitation was set up in the Dimension.

If i go ahead with this solution, my dimension filter would not work.

Can you suggest any alternative solution ??