Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

pennetzdorfer
Contributor 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
Valued Contributor III

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

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

pennetzdorfer
Contributor III

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

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

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

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
Contributor III

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

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

Community Browser