0 Replies Latest reply: Feb 13, 2018 1:06 PM by Serjoscha Szillat RSS

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

    Serjoscha Szillat

      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