Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

amanjain57
Contributor

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 ??

4 Replies
MVP
MVP

Re: Filter pane not showing values

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
Contributor

Re: Filter pane not showing values

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.

MVP
MVP

Re: Filter pane not showing values

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

amanjain57
Contributor

Re: Filter pane not showing values

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 ??