Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using master measures/dimension in formulas

Hi,

I defined some master measures/dimensions and I'd like to use them in other formulas without writing entirely the formula adopted.

One possible way could be using variables but I prefer not using them.

Is it possible in this new Qlik version or we still need to wait for this implementation?

Thanks,

Marc

24 Replies
morenoju
Partner - Specialist
Partner - Specialist

Hi, any news on this? Is it possible in newer versions of Qlik Sense? Thanks

DGO
Contributor III
Contributor III

It's still not possible in Qlik Sense Cloud as of today. Robot Sad

jfortner2
Contributor III
Contributor III

Hey Michael. Is this feature available yet or do you have any update on when it might be released?

isozander
Partner - Contributor II
Partner - Contributor II

One way of using master items in expressions is by adding them to a table.

Then you can simply reference Column(1) for example in the next expression where you refer to the master item by it's column number in the table.

DGO
Contributor III
Contributor III

@Michael_Tarallo  Hi Michael, will this feature get implemented in Qlik Sense?

thi_pham
Creator III
Creator III

In measure, I can use other master measures, like this:

 - Measure 3 formular = [Master Measure 1] + [Master Measure 2]

It works well, just put the Master measure name in [...]

However, in master measure, It doesn't work with master dimension.

Qlik sense server version June 2019 

One more point FYI, this kind of master measure seems not work in some charts, I tried fine on table, but not work on scatter plot. 

adrianomundim
Partner - Contributor II
Partner - Contributor II

Hi.

 

I am using the formulas in variables. In the Master Measures, I use the variable with dollar sign expansion ($) and, when I need the formula in a expression, I write the expression using the variable with dollar sign expansion too. 

 

Is this a problem to perfomance or other bad issues?

 

Thanks.

jasmina_karcic
Creator III
Creator III

What is situation for this...I really need it...

 

Jasmina

thi_pham
Creator III
Creator III

what kinds of situation you gonna need it?

tschogren
Contributor II
Contributor II

Thi_Pham, many situations. It would make it so much easier and helpful to use Master items if we're able to them reference them by name again.