topic Re: Help with variable based dimension switching in App Development

Help with variable based dimension switching

Anonymous — Wed, 06 Sep 2017 21:44:12 GMT

I am using a variable based dimension switch on a Qlik Sense report as follows:

Dimension expression: [$(vDimLevel1]

The vDimLevel1 variable holds a string value of a field name, that is derived based on some other criteria, that I do not want to complicate this discussion with. So keeping it simple, this variable gets a field name (string), which then the expression converts to an actual field name.

It works!

It works just fine when I use it on a pivot table and also as a dimension in a chart.

Funny thing, Qlik Sense does not like it when I add such an expression, as a second dimension in any kind of visualization object.

The same exact expression works just fine when used as a second dimension in a Pivot table.

This is driving me crazy.

Is this a Product bug or do chart axes (2nd dimension) need a different format of $ expansion or something?

Plz help... plz plz plz

Re: Help with variable based dimension switching

sunny_talwar — Thu, 07 Sep 2017 01:04:16 GMT

This is strange... would you be able to mock up a sample where we can see the issue?

Re: Help with variable based dimension switching

Anonymous — Fri, 22 Sep 2017 15:27:19 GMT

This seems to be a bug, and is currently with Qlik support.

Also, looks like I missed an important part of the story.

This error does not occur, if I use static variables.

It happens when I used an expression in a variable and then use a dollar sign expansion with the variable, at run-time to switch dimensions. It throws an error, when using such in the 2nd dimension in a graph.