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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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?

Labels (1)
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

?