topic Re: Values of variable differ at script level and in text box in QlikView

Values of variable differ at script level and in text box

ferha_jafri — Mon, 13 Jul 2015 03:32:53 GMT

Hello Everyone,

I am facing an issue I am using a variable at script as SET Var1=sum({$<Date={">=$(Date(Max(Date)-7))<=$(=Max(Date))"}>}Mencount)

when I am using this expression in text box I am getting 10.5 and if I am using the variable directly into text box as $(Var1) I am getting 12.6 ,not able to understand why???Please help in understanding this.

Thank you

Regards

Ferha

Re: Values of variable differ at script level and in text box

sunny_talwar — Mon, 13 Jul 2015 03:37:26 GMT

Not sure why you would get different results. Would you be able to share your application or a sample?

Re: Values of variable differ at script level and in text box

vardhancse — Mon, 13 Jul 2015 03:50:07 GMT

No chance of getting different value, once can check the expression

Re: Values of variable differ at script level and in text box

svenkita — Mon, 13 Jul 2015 03:56:47 GMT

could you share the sample application.

normally there should not be a difference in the answers.

do you have alternate states in the application. then the values could differ depending on the state in which the formula is.

Re: Values of variable differ at script level and in text box

Mon, 13 Jul 2015 04:11:37 GMT

Hi,

Its preferable to use 'num' of date field in the variable, and convert the variable into date after variable is evaluated.

Try this.

SET Var1=sum({$<num(Date)={">=$(Date(Max(num(Date))-7))<=$(=Max(num(Date)))"}>}Mencount)

and use the variable as date(Var1)

Re: Values of variable differ at script level and in text box

ferha_jafri — Mon, 13 Jul 2015 11:21:25 GMT

the exp

Var1=sum({$<Date={">=$(Date(Max(Date)-7))<=$(=Max(Date))"}>}Mencount) gives correct value everywhere but if I divide this variable by 13 in script this is not getting reflected in the calculation although if write $(Var1)/13 in the front end it is giving the correct value.

Re: Values of variable differ at script level and in text box

ferha_jafri — Mon, 13 Jul 2015 11:22:14 GMT

why this is happening not understand...

Re: Values of variable differ at script level and in text box

sunny_talwar — Mon, 13 Jul 2015 11:29:48 GMT

Are you doing it like this?

SET Var1=sum({$<Date={">=$(Date(Max(Date)-7))<=$(=Max(Date))"}>}Mencount)/13 and then $(Var1) doesn't seem to give the right result????

Re: Values of variable differ at script level and in text box

ferha_jafri — Mon, 13 Jul 2015 11:40:55 GMT

Right