Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lbrosten
Contributor III
Contributor III

Can a variable be used in an expression instead of a Master Measure

I created a master item, Incurred Costs

Sum([OS Indemnity Reserve]+[OS Expense Reserve]+[Indemnity Paid]+[Expense Paid])

I want to use this Master item expression in the creation of other master items. Is there a way to do this?

Would creating a variable of this expression work?

Can you help create a master item which shows Incurred Costs when the 'Claim Status' is 'Closed'.

 

1 Solution

Accepted Solutions
chris_djih
Creator III
Creator III

You can, just strat typing "Incurred Cost", the auto-complete assistant will offer you the master Measure in the dropdown which is indicated by a blue "measure".

for your second task use Set-Analysis : {<[Claim Status]={'Closed'}>}

If you found help, mark the correct answer and give some likes to ALL contributors, that tried to help.

View solution in original post

2 Replies
chris_djih
Creator III
Creator III

You can, just strat typing "Incurred Cost", the auto-complete assistant will offer you the master Measure in the dropdown which is indicated by a blue "measure".

for your second task use Set-Analysis : {<[Claim Status]={'Closed'}>}

If you found help, mark the correct answer and give some likes to ALL contributors, that tried to help.
Marcel_Garcia
Contributor III
Contributor III

It should work.
Try creating a variable 'vIncurred_Cost' = 

Sum([OS Indemnity Reserve]+[OS Expense Reserve]+[Indemnity Paid]+[Expense Paid])

and then use $(vIncurred_Cost) in a different Master Item.
Good luck.