Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
ClementByr
New Contributor III

Use a calculated dimension in a formula

Hello,

In the storyboard, I want to define a calculated dimension called vINSTRUCTION that I will use in many formula.

Here is the calculated dimension : if(IsNull([RATIO.INSTRUCTION]), [ERRORS.INSTRUCTION], [RATIO.INSTRUCTION])

I tried to create a formula like Count(vINSTRUCTION) but vINSTRUCTION does not appear in the dimension pane.

I also tried to do this as a variable but the formula count(vINSTRUCTION) count the dimension as a variable not as dimension (return 1).

Does know a way to keep this calculated dimension in some sort a variable so I can re-use it in many formula.

Best regards.