Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
stabben23
Partner - Master
Partner - Master

Divide variable in expression

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

14 Replies
saumyashah90
Specialist
Specialist

it should, try  vNetsales/1000

senpradip007
Specialist III
Specialist III

Hi Staffan,

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

Hope this help you requirment.

Not applicable

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

stabben23
Partner - Master
Partner - Master
Author

Hi, Wont work

stabben23
Partner - Master
Partner - Master
Author

Absolutly NOT, sorry

Not applicable

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

saumyashah90
Specialist
Specialist


Please check this

Not applicable

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

stabben23
Partner - Master
Partner - Master
Author

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