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
Not applicable

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

nizamsha
Specialist II
Specialist II

Try this one

='$(vNetSales)'/1000

Not applicable

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

Not applicable

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

Not applicable

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....