Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a new Master Item Measure using a complex expression. Let's name this as Measure 1. I want to create a 2nd Master Item Measure or add a new Measure in my visualization derived using a logic involving Measure 1. I am trying to use Measure 1 to apply the logic in the expression editor and Qiksense does not allow Measure 1 to be reused. So, when I define Measure 2, I will have to explode the logic of Measure 1 and add further logic to it making it very complicated. Is there a way that a Master Item can be reused to derive other Measures?
Hi,
As far as I know qlik does not let you reuse master item measures.
But you can create a variable instead, and use that variable in you new measue.
just using $(yourVariableName)
You can create it in this icon:
Regards,
Sílvia
Hi,
As far as I know qlik does not let you reuse master item measures.
But you can create a variable instead, and use that variable in you new measue.
just using $(yourVariableName)
You can create it in this icon:
Regards,
Sílvia
Thank You Silvia. That was helpful.
There is a Power Tool from Qlik for Governed Metrics that would allow you to do this. I started taking a look at it and got side tracked.
I have a derived field named 'Difference'. I am trying to colour code this based on an expression. i.e. If the value in this field is above a threshold I would like to highlight in Red. Should I use a variable again here? This Derived Measure is not showing up on the expression editor. Is there any function to say 'the Current field value'?
True,
PowerTool is a great tool - however you do not know how long it is going to be supported for and also you cannot rely that it will be updated and compatible with every new release of QlikSense. Therefore master data library build from variables would be more painful at the beginnig but safer option to implement and i suggest that.
regards
Lech