topic QV10 bug or expected behaviour? in QlikView

QV10 bug or expected behaviour?

isaiah82 — Tue, 18 Jan 2011 19:05:01 GMT

Through QV9 I have used the "Show All Values" dimension property in charts to show ALL dates relevant over a given period in conjunction with the "Supress When Value is Null" property, even if for the given selections there are no transactions for a specific date. I have noticed with version 10 the behaviour has changed such that an additional row will be displayed (with a null value.)

The attached QVW depicts this. In this example, I don't have any Magazine quantities for the week ending 12/17, but still want to see a column when using the date field in a pivot table. Works as expected in v9, but I can't make it work cleanly in v10.

Has anyone else come across this or have any suggestions for workaround? I'm wondering if this change between v9 and v10 is intended?

Thanks -Isaiah

QV10 bug or expected behaviour?

isaiah82 — Thu, 20 Jan 2011 14:41:30 GMT

Any thoughts? To clarify, I'm trying to show all dates in a pivot table regardless of whether or not there are matching fact records based on selections.

QV10 bug or expected behaviour?

isaiah82 — Fri, 21 Jan 2011 17:57:24 GMT

QlikTech support confirmed this is a known bug:

"Defect 30915 has been approved by R&D, however due to uncertainties regarding potential related problems and program priorities we cannot guarantee a fix date at this time."