Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Minimun of variables

Hi,

I have created 3 variables and used this function

=Min(Variable1,Variable2,Variable3) but its not working

When I use

=Min(fieldname) Its working fine

Why this variation between variables and fields.

Can anyone come across this.

Thanks,

3 Replies
Not applicable
Author

Hi,

there are some things to mention:

using variables you should use the $()-Operator, i.e. Min( $(Variable1), $(Variable2), ....). Second, and even more important is, that the Min()-Function will only work inside a chart-formula. Because it is an aggregate-function. Third, proper working depends of the content, if you have only plain figures (i.e. constant values) in your variables, it won't work as well. Try two test-cases: in a text object and in a formula of a chart box.

Hope this helps, don't hesitate asking q.

Roland

johnw
MVP
MVP

=rangemin(Variable1,Variable2,Variable3)

Not applicable
Author

Exactly matching John's formula.

Thanks John.

Thanks,