QlikSense: Expression does not reduce DimensionValues (since Sep'17 Release)

serjoscha_szillat — Tue, 13 Feb 2018 18:06:39 GMT

Hi Community,

I would appreciate your help in following issue:

We upgraded QS-release from 3.2 to september release.

We used several bar charts. The dimensions are time (Week) and Category. The expression is a sum of values, limited to past 3 weeks based on max possible date. Meaning, once the user selects a date, the expression displays past three weeks of the selected date.

That scenario worked properly before upgrading QS-release. Unfortunately after we upgraded to Release September 2017 that chart reacted differently.

--> Time dimension was no longer reduced by expression. I found the entire range of the dimension without any chance to reduce it by expression.

I found no "clean" way to solve this problem.

Workaround 1:

Result set of Dimension ''Week'' gets shrinked by usage of aggr(only()), so that view is limited to past 3 weeks.

Unfortunately the chart does not react to changes made in filter ''Date''. Additionally aggr() in Dimension is bad performance.

Workaround 2:

Option ''Include zero values'' in Section ''Add-Ons'' is deactivated.

Unfortunately all zero-values disappear (even for "past 3 weeks"), so that worthwhile information possibly does not get displayed.

Workaround 2.1:

Same scenario as in Workaround 2...

To avoid hiding zero-values within "past 3 weeks" I added an extremely small value (+ 0.0000001) to the expression --> not visible for user. This works but I guess we agree on the statement that manipulation of values should be prevented in all cases.

Does anyone have an idea on that one?

To make this scenario more understandable I built an exemplary app and uploaded .qvf-file.

Hope to get some good ideas. Thanks in advance for your time.

Serjoscha

topic QlikSense: Expression does not reduce DimensionValues (since Sep'17 Release) in App Development

QlikSense: Expression does not reduce DimensionValues (since Sep'17 Release)