topic Re: Round function with variable in QlikView

Round function with variable

tobiasaechter — Sat, 16 Nov 2024 01:08:07 GMT

Hi,

I am trying to create a round function with a variable but only receive error messages.

Idea is to write sth like: Round(Var A, 0.1,0). The varibale is defined in the variables section of the dashboard before.

When putting this in a chart/textbox,... I receive an error saying: Error in Expression: ')' expected

If I write the variable directly into my expression it works though.

for example: Var A = 1/2

Round(Var A, 0.1,0) -> the above mentioned error

Round(1/2,0.1,0) -> results in a value though

Can someone please help me what is going wrong here?

Thanks

Anil_Babu_Samineni — Wed, 04 Mar 2020 13:19:59 GMT

May be use $ expansion over variable like

Round($(Var A), 0.1,0)

Round($(=Var A), 0.1,0)

tobiasaechter — Wed, 04 Mar 2020 13:25:40 GMT

I have tried that already, but that did not help unfortunately

Anil_Babu_Samineni — Wed, 04 Mar 2020 13:27:39 GMT

Where did you created this variables? Is that "Variable Overview" / "From Script" etc. May be provide screen shot for that

tobiasaechter — Wed, 04 Mar 2020 14:32:28 GMT

Found the problem:

Variable was created in Variable Overview, but it also included a line of commented code below the code actually in use.

Removing the part of the variable which was commented solved it.

now it works.

Thanks though.