Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
pennetzdorfer
Creator III
Creator III

Pivot table: Dimension "Dropdown select" issue (bug?)

I noticed a strange behavior: in my pivot chart I use the dropdown select option. That works smoothly for all dimensions ... except for the very last dimension.

When hitting the dropdown arrow of "dim2" I get the following result:

1.jpg

As soon as I add an expression (or even some subsequent dimensions) it works:

2.jpg

In my specific cas I would like to use a pivot table without any expressions and it's a pity that the last dimension isn't searchable ... is that a bug?!

Please find the attached qvw.

Thanks,

Florian

4 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

Can't you use a Straight Table for this? It would be the same and it works.

pennetzdorfer
Creator III
Creator III
Author

Thanks, but pivoting is necessary in that case. As a workaround I will simply add a narrow empty calculated dimension at the end ... not beautiful, but at least it works.

How can I report that as a bug?

Regards,

Florian

marcus_sommer

It isn't a bug - it worked as designed. A pivot need  a expression. But you could set the width from these expression on 0:

sub x

set chart = ActiveDocument.GetSheetObject("CH02")

chart.SetPixWidth 0,100

chart.SetPixWidth 1,100

chart.SetPixWidth 2, 0

end sub

- Marcus

pennetzdorfer
Creator III
Creator III
Author

I don't really understand why a pivot shouldn't work without an expression (a straight table does)

Thanks for your macro tipp ...

Regards,

Florian