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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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