Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Variable has same formula but gives different number

Hi. 

I have a variable that is equal to count (<some condition> ID), but when I put it in bar chart, with the dimension being month and the measure being the variable, I get a the same number for each month. Are we allowed to use variables to store calculations that aren't constant?

Labels (2)
1 Solution

Accepted Solutions
Highlighted

Re: Variable has same formula but gives different number

In your variable definition, if you start it with an = it is calculated outside of your chart.  Remove the = from the front of the variable definition, and it will calculate it according to whatever chart you use it on.

View solution in original post

2 Replies
Highlighted

Re: Variable has same formula but gives different number

In your variable definition, if you start it with an = it is calculated outside of your chart.  Remove the = from the front of the variable definition, and it will calculate it according to whatever chart you use it on.

View solution in original post

Highlighted
Specialist III
Specialist III

Re: Variable has same formula but gives different number

Hi,

While created the Variable if you put = before the expression i will calculate the value and it will store one value in that variable.

remove the = before the expression and use =$(your variable) then i will calculate as per your Dimension.

 

Thanks,

Mohammed Mukram