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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
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....