Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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."
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.
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."