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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying a value stored as variable as an interval (seconds)

I have a variable called vAHTCalc and need to show this formatted as a variable to show seconds.

I have created what I believe to be the correct expression as below but get an error 'Error: Error in expression: ')' expected.


=Interval($(vAHTCalc),'ss')

I'm just trying to display this in a text box for now so not doing anything too complicated. What am I missing?

6 Replies
Anonymous
Not applicable
Author

What is in the variable?  What you see in a text box if you use just

=vAHTCalc

sujeetsingh
Master III
Master III

I agree with Mich and i just doubt that, the variable will always have a single value hence is it like you want a same value in your UI.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

That sounds like your variable doesn't return a number but a text value.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

I suspect it is a text of expression, but what do I know? 

Not applicable
Author

Its an interval. I think I've got a formatting problem as I've now fixed that issue by changing the expression of the variable to an interval but now  I want to divide 3600 by said variable (interval) and I'm back to 'Error: Error in expression: ')'

=num(3600/$(vAHTCalc),'##.##')

Not sure I can what I'm trying to do

Thanks

Gavin

Anonymous
Not applicable
Author

You can, if you do it right...  Again, what is in the test box if you try

=vAHTCalc

?