topic Re: Divide variable in expression in QlikView

Divide variable in expression

stabben23 — Wed, 09 Oct 2013 06:12:26 GMT

Hi I have a variable 'vNetSales' sum(Value), when I use this in a Bar chart in the expression like $(vNetsales)/1000 nothing happens, the value wont get divided. This is not a problem, I can use sum(Value)/1000 in my expression but I wondering why this dont work.

//Stabben

Re: Divide variable in expression

saumyashah90 — Wed, 09 Oct 2013 06:14:50 GMT

it should, try vNetsales/1000

Re: Divide variable in expression

senpradip007 — Wed, 09 Oct 2013 06:19:19 GMT

Hi Staffan,

In variable vNetSales an equal sign ( = ) should preceeds of variable ie =sum(Value).

Hope this help you requirment.

Re: Divide variable in expression

Wed, 09 Oct 2013 06:20:47 GMT

Dear Sir/Madam,

Thank you for your E-mail. We may or may not have received your mail. Please forward the same mail to my new mail id hitesh.makwana@goapl.com again.

Kindly update your address book for future communications.

Rgds,

Hitesh Makwana

022, 42187749

Re: Divide variable in expression

stabben23 — Wed, 09 Oct 2013 07:20:41 GMT

Hi, Wont work

Re: Divide variable in expression

stabben23 — Wed, 09 Oct 2013 07:21:02 GMT

Absolutly NOT, sorry

Re: Divide variable in expression

Wed, 09 Oct 2013 07:21:36 GMT

Dear Sir/Madam,

Thank you for your E-mail. We may or may not have received your mail. Please forward the same mail to my new mail id hitesh.makwana@goapl.com again.

Kindly update your address book for future communications.

Rgds,

Hitesh Makwana

022, 42187749

Re: Divide variable in expression

saumyashah90 — Wed, 09 Oct 2013 07:28:16 GMT

Please check this

Re: Divide variable in expression

Wed, 09 Oct 2013 07:29:24 GMT

Dear Sir/Madam,

Thank you for your E-mail. We may or may not have received your mail. Please forward the same mail to my new mail id hitesh.makwana@goapl.com again.

Kindly update your address book for future communications.

Rgds,

Hitesh Makwana

022, 42187749

Re: Divide variable in expression

stabben23 — Wed, 09 Oct 2013 07:37:30 GMT

Hi,

Yes this works in this case, BUT I hav A LOT of tables (pivot,Straight, whatever) that use this Variable. Your solution wont work over dimenssions.

Thanks anyway

Re: Divide variable in expression

Tue, 18 Feb 2014 10:59:52 GMT

did you managed to make it work? I have the same issue.

Re: Divide variable in expression

nizamsha — Tue, 18 Feb 2014 11:05:01 GMT

Try this one

='$(vNetSales)'/1000

Re: Divide variable in expression

Tue, 18 Feb 2014 13:20:50 GMT

Still not working thx, hope somebody can give me a clue ...

Re: Divide variable in expression

Tue, 18 Feb 2014 13:47:56 GMT

Did you write correctly your expression ? QV is case sensitive (take care)

because that is correct:

I have done v1 - Sum(Sales) in Variable Overview window (no = sign to get an interpretation for all rows)

In the expression, I have done

$(v1)/100 or $(=v1)/100 : both work perfectly

(no quotes)

Fabrice

Re: Divide variable in expression

Tue, 18 Feb 2014 18:53:55 GMT

in the end in my example where my variable (vA) defined an expression using variable. My solution that worked was $(v1)/$(=$(vA)) Thank you for your posts it helped my thinking....