topic Re: Displaying a value stored as variable as an interval (seconds) in QlikView

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

Fri, 08 May 2015 11:24:39 GMT

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?

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

Anonymous — Fri, 08 May 2015 11:30:07 GMT

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

=vAHTCalc

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

sujeetsingh — Fri, 08 May 2015 11:33:40 GMT

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.

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

Gysbert_Wassenaar — Fri, 08 May 2015 12:21:29 GMT

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

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

Anonymous — Fri, 08 May 2015 12:31:02 GMT

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

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

Fri, 08 May 2015 14:53:46 GMT

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

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

Anonymous — Fri, 08 May 2015 16:14:51 GMT

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

=vAHTCalc