Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
gwmills_fiserv
Partner
Partner

I want to create a dimension where I can assign a speciffic value.

I have a data model with value for different types of collateral.   I would like to divide the total by a specific number, but there is no field for that value.   I want to create a dimension that would hold the specific value so I an reuse it in calculations.  For example, I want to assign the value $750,000,000 to the dimension named Capital.

If I could make it driven by a variable that could easily  be changed, that would be a bonus.

Labels (2)
3 Replies
Anil_Babu_Samineni

Question not clear to me. Can you rephrase for me
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
PeterVanOers
Contributor III
Contributor III

If I understand you correctly a variable is the solution.

Somewhere in the load script:

Set vCapital=750000000;

In a calculation:

=Sum(FieldToSum)/$(vCapital)

In the november version with de Dashboard Bundle there's an extension called variable input which you can use to modify your variable.

Regards Peter.

gwmills_fiserv
Partner
Partner
Author

Thank you!   That worked.