topic Calculated dimensions in Sense in App Development

Calculated dimensions in Sense

patrik_seger — Tue, 21 Jun 2016 15:11:16 GMT

After created a calculated dimension in Qlik Sense, I use it as field to select. The naming in the field was correct, but when I have selected some values in this, the selection is named after the Expression and not the label I set for the Dimension.

Is this a feature or a bug?

Br Patrik

Re: Calculated dimensions in Sense

swuehl — Tue, 21 Jun 2016 20:06:13 GMT

Selections are made on fields in your data model.

If your calculated dimension is rather static, I would suggest to create a new field in your data model that filter, e.g. Customers in Germany. Then use this new field in your dimensions and filters.

If you don't want to do this and if you want to show the field you are selecting in instead of the expression, I think you can use something like (don't know your exact calculated dimension, thus showing just something I made up):

=Aggr( If(Mid(Customer,1,2)='DE',Customer), Customer)

Re: Calculated dimensions in Sense

rwunderlich — Tue, 21 Jun 2016 20:16:34 GMT

Adding detail to what Stefan has suggested.

Scoping Selections with Aggr() | Qlikview Cookbook

-Rob

http://masterssummit.com

http://qlikviewcookbook.com