hard coded chart KPI in a different expression in a different chart

[ugurarslan]

 Dear all,

I have a chart object "KPI" where I fill in manually a number like '10', which I need to change on a daily base. 

I also have a different chart "Table" where in the expression I need to include the hardcoded value. Example of an expression: Sum([AR USD]) * '10'.

Is there a possibility to have a get field selection for the hardcoded number in the expression so I only need to update the KPI and all different expressions related to this KPI will be changed automatically. Like something Sum(AR USD) * 'GetHardCoded value in KPI'.

A variable will not work in this case as due to security reasons this option is close.

Thanks for all the great help.

Ugur

[ugurarslan]

I have a chart object "KPI" where I fill in manually a number like '10', which I need to change on a daily base. 

I also have a different chart "Table" where in the expression I need to include the hardcoded value. Example of an expression: Sum([AR USD]) * '10'.

Is there a possibility to have a get field selection for the hardcoded number in the expression so I only need to update the KPI and all different expressions related to this KPI will be changed automatically. Like something Sum(AR USD) * 'GetHardCoded value in KPI'.

A variable will not work in this case as due to security reasons this option is close.

Thanks for all the great help.

Ugur

[vikramv]

If not variables, You can try with the extension objects as we do not have option for input field in Sense...

Check this link....

https://developer.qlik.com/garden/56728f52d1e497241ae697f8

[Anil_Babu_Samineni]

Try this?

Sum(AR USD) * Pick(Match(DateField, 'Today', 'Yesterday'), 10,20)