Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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