topic Re: Cycle group dimension in Sense in App Development

Cycle group dimension in Sense

dadumas — Sat, 16 Nov 2024 18:02:50 GMT

I read a great article to achieve a cycle dimension in Sense, but cannot get it to work. Fails when referencing the calculated dimension expression in a chart.

I have an inline table in my model:

AdHocDimensions:

Dim,DimSort

Region,1

Sales Person,2

etc...

works great, tests fine

I then create 2 variables:

vMinDimSort, defined as: min(DimSort) This displays fine

vDim, defined as : minstring({<DimSort={"$(=$(vMinDimSort))"}>} Dim) thiis works, but only when defined using a search string with the double quotes syntax.

The article says to code vDim simply as : minstring({<DimSort={$(vMinDimSort)}>} Dim) but his gives a "set modifier error" . I have even put single quotes around $(vMinDimSort), but same error.

When I define vDim without the error, I can display $(vDim) as a measure in a textbox, so that that works fine, Example: Region displays as expected in a textbox.

Then in my chart, I use =[$(vDim)] as a calculated dimension

Does not work, gives a set analysis error. I would expect that if the textbox works with this variable, then the dimension reference with that same variable should work.

Any ideas?

Dave

Re: Cycle group dimension in Sense

dadumas — Tue, 29 Sep 2020 15:22:35 GMT

I have simplified the variable vDim, used for the dimension to be defined simply as: only(DimName)

I am seeing that when using this as the expression for a dimension dimension in a chart, =[$(vDim)] gives an error in the expression editor of : "Error in Expression" =[only(DimName)]

So, in summary it does not appear to work to base a dimension on an expression that is based on text strings sourced from an inline table where the source strings match the dimension names. I have no clue how anyone got the example used in the article to actually work.

Dave

Re: Cycle group dimension in Sense

dadumas — Tue, 29 Sep 2020 15:44:38 GMT

I got this to work. You have to reference the dimension expression in the chart as : =[$(=$(vDim))]

So, in summary, to create a cycle group dimension in qlik sense:

vDim should be defined as : minstring({<DimSort={"$(=$(vMinDimSort))"}>} DimName)

The label for the dimension should be defined as: ='$(=$(vDim))'

5 hours to figure this out 😞

Re: Cycle group dimension in Sense

dadumas — Tue, 29 Sep 2020 15:42:05 GMT

vDim is now defined correctly as:

minstring({<DimSort={"$(=$(vMinDimSort))"}>} DimName)

And this is how you have to reference the label of the Dimension: ='$(=$(vDim))'

Dave