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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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