Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

explination?

1*sum($('product='fruit',[month]=,year={'$(vmaxyear)'}>}sales)/vsales

what it gives

3 Replies
maleksafa
Specialist
Specialist

you need to elaborate more your variables to understand this expression, how are you calculating vmaxyear and vsales.

but from what i see it is taking the sum of sales for the product = fruit, ignoring the month selection where year = vmaxyear( depends what is this variables) / vsales.

Anonymous
Not applicable
Author

in simple what we can write label name for above one

maleksafa
Specialist
Specialist

it depends what is the vSales variable, if in your case the vSales returns all the sales for this year, then your expression is returning the "Fruit Sales Contribution per Year".