topic Re: syntax error using a variable not an expression in QlikView

syntax error using a variable not an expression

becki_kain — Wed, 25 Nov 2020 16:16:04 GMT

I use this expression as, well an expression (column):

round((sum({1<[TP]={$(TP1)}>}Volume)/$(total_sales_vol_tp1))*100,.1)

where $(total_sales_vol_tp1) is a variable which I set instead of defining that as a separate expression (column) and this expression is fine. but if I replace this:

Round(((AA1/AA3)*100), 0.01) where AA1 and AA3 are expressions (columns)

with Round(((AA1/$(total_sales_vol_tp1))*100), 0.01)

I get errors in expression even though all the paranthese match up and i'm just swapping in the variable. what am I doing wrong, as a new person?

thanks

becki kain

Re: syntax error using a variable not an expression

vishsaggi — Wed, 18 Oct 2017 20:09:53 GMT

May be try this?

Round(((AA1/ '$(total_sales_vol_tp1)')*100), 0.01)

Re: syntax error using a variable not an expression

becki_kain — Wed, 18 Oct 2017 20:15:21 GMT

with just adding the ''? nope

'$(total_sales_vol_tp1)'

I still get errors in expression

Re: syntax error using a variable not an expression

lorenzoconforti — Wed, 18 Oct 2017 20:51:46 GMT

Can you please share how total_sales_vol_tp1 is defined?

Re: syntax error using a variable not an expression

vishsaggi — Wed, 18 Oct 2017 20:53:32 GMT

Can you share the expressions you are using for AA1, AA3 and your variable expression too.

Re: syntax error using a variable not an expression

becki_kain — Wed, 18 Oct 2017 21:40:01 GMT

=sum({1<[TP]={$(TP1)}>}TOTAL Volume)

Re: syntax error using a variable not an expression

becki_kain — Wed, 18 Oct 2017 21:43:30 GMT

aa1 is =round((sum({<[TP]={$(TP1)}>}Volume)/$(total_sales_vol_tp1))*100,.1) as a field/column/expression

aa3 is sum(TOTAL{<[TP]={$(TP1)}>}Volume)

variable is =sum({1<[TP]={$(TP1)}>}TOTAL Volume)

Re: syntax error using a variable not an expression

lorenzoconforti — Wed, 18 Oct 2017 21:46:15 GMT

Try removing the equal sign

Re: syntax error using a variable not an expression

becki_kain — Wed, 18 Oct 2017 21:48:08 GMT

that's not where i'm getting the error. i'm getting the error at :

Round(((AA1/$(total_sales_vol_tp1))*100), 0.01)

Re: syntax error using a variable not an expression

lorenzoconforti — Wed, 18 Oct 2017 21:50:53 GMT

I understand

try removing the equal sign from your variable definition

sum({1<[TP]={$(TP1)}>}TOTAL Volume)

without the equal sign at the beginning

Re: syntax error using a variable not an expression

vishsaggi — Wed, 18 Oct 2017 21:51:37 GMT

Try this and see if you gettting error?

= round(

(

((sum({<[TP]={$(TP1)}>}Volume)/$(total_sales_vol_tp1))*100)

sum(TOTAL {< [TP]= { $(TP1) } >} Volume)

)*100,.1

)

If this does not work can you share your sample file if possible?

Re: syntax error using a variable not an expression

becki_kain — Wed, 18 Oct 2017 21:53:12 GMT

what equal? there is only one equal and it's not at the beginning so i'm confused

thanks

Re: syntax error using a variable not an expression

lorenzoconforti — Wed, 18 Oct 2017 21:57:17 GMT

See screenshot below. Do you have an equal (highlighted below in black) as first character in your variable definition?

Re: syntax error using a variable not an expression

becki_kain — Wed, 18 Oct 2017 22:08:48 GMT

yes. opps. let me check now

Re: syntax error using a variable not an expression

becki_kain — Wed, 18 Oct 2017 22:15:22 GMT

didn't help. same error with no = at beginning of variable expression and like I said, it works in other equations. that's the part I don't get

Re: syntax error using a variable not an expression

lorenzoconforti — Wed, 18 Oct 2017 22:16:37 GMT

Is there any chance you can post your application?

Re: syntax error using a variable not an expression

matteo_mi — Thu, 19 Oct 2017 10:02:17 GMT

can you show if you put this in the variable total_sales_vol_tp1?

sum( TOTAL {1<TP = {$(TP1)}>} Volume )

also what contain variable $(TP1)?

Re: syntax error using a variable not an expression

becki_kain — Thu, 19 Oct 2017 17:33:11 GMT

that doesn't change anything. still error. $(TP1) is a user picked time period in the format of P_201709

Re: syntax error using a variable not an expression

becki_kain — Thu, 19 Oct 2017 17:33:57 GMT

same error. 😞

Re: syntax error using a variable not an expression

becki_kain — Thu, 19 Oct 2017 17:36:12 GMT

(((BB3/BB1)-(BB6/BB2))*BB1)/(sum({1<[TP]={$(TP1)}>}TOTAL Volume)) also gives "error in expression!"