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

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

pennetzdorfer — Wed, 31 Jul 2013 13:04:10 GMT

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:

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

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

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

jvitantonio — Wed, 31 Jul 2013 16:36:15 GMT

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

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

pennetzdorfer — Thu, 01 Aug 2013 09:48:30 GMT

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

marcus_sommer — Thu, 01 Aug 2013 12:14:49 GMT

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

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

pennetzdorfer — Mon, 05 Aug 2013 06:35:03 GMT

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