Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Reliability-Engineer
Contributor III
Contributor III

Using Variable in expression for Graph

Currently I have the below graph based on a value in the table (TIJD)

I do however want to base it on a calculated value.  For this calculated value I created a Variable :  vTL%

vTL% : (((Sum({<VolgNr ={1}>}[Tijd]) + Sum({<VolgNr ={2}>}[Tijd])+Sum({<VolgNr ={3}>}[Tijd]) + Sum({<VolgNr ={4}>}[Tijd])+Sum({<VolgNr ={5}>}[Tijd]) + Sum({<VolgNr ={6}>}[Tijd])+Sum({<VolgNr ={7}>}[Tijd])
 +
Sum({<VolgNr ={8}>}[Tijd])+ Sum({<VolgNr ={9}>}[Tijd]) + Sum({<VolgNr ={10}>}[Tijd])+ Sum({<VolgNr ={11}>}[Tijd]) + Sum({<VolgNr ={12}>}[Tijd])) / Sum({<OE_HfdCode={'TijdBenut'}>}[OE_Tijd]))) * 100

Putting this in the default expresion does not work      Sum({<[Zone]={'Zone 9-10'}>} $(vTL%)

How must I setup my expression to make this work?

Thanks.

Jan

QV-01.jpg

Labels (2)
10 Replies
Reliability-Engineer
Contributor III
Contributor III
Author

I'll follow your advice.

Thanks for helping so far.

Jan Droog