Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
swetasingh
Partner - Contributor III
Partner - Contributor III

Variable Calculation works in KPI but not in tables

Hi, 

I have a measure which works perfectly fine in a KPI and gives correct output on user input. 

However when i try to save the same output in table it gives me different results. Please see below example. 

Formula = Rangemax(1, RangeMin( $(v1) + $(v2) + $(v3), 100)) = KPI value works fine.

v1, v2, v3 and v4 are variables calculated on user input. 

Now I am saving the current selection in table , but when the use the same Formula it gives me different value than KPI. 

Any Idea why ?

Labels (3)
7 Replies
sunny_talwar

May be try this

RangeMax(1, RangeMin(RangeSum($(v1), $(v2), $(v3)), 100))

 

dplr-rn
Partner - Master III
Partner - Master III

whats your expressions for the variables?
If it has set analysis; note that set analysis is calculated once per table not line by line
swetasingh
Partner - Contributor III
Partner - Contributor III
Author

I have tried this gives me the same result. 

swetasingh
Partner - Contributor III
Partner - Contributor III
Author

Yes my variables has set analysis. 

Is there any alternative way to store the value coming from KPI in a table so that the user can save it. 

I tried creating another table in the same sheet by dimension , where the formula works correctly. 

sunny_talwar

How exactly do you define v1, v2, v3?

swetasingh
Partner - Contributor III
Partner - Contributor III
Author

v1 v2 and v3 are complex calculations coming from other variables getting calculated from user input values

sunny_talwar

okay... unless you are able to share a sample where this can be seen, it would be rather difficult to help.