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: 
Not applicable

Dynamic Scale in Trellis Chart

Hi All

i make a Trellis Chart and i am having problem with the scale , i have a sum(cnt) for each country by date but not all country's have the same SUM(CNT) so the scale is allways 200,000 , for italy its good but for Belgium i dont see the cnt

error loading imageerror loading image

3 Replies
Not applicable
Author

Try setting the static max of the axes using

=floor(max(aggr(sum(CNT),RECORD_DATE)))

Not applicable
Author

Hi

Thank you for your help but still the same , now i am geeting MAX 1,400,000 for all , i insert it in the static max

i also try

=floor(max(aggr(sum(CNT_LOC_DY),RECORD_DATE,COUNTRY_DESC)))



kji
Employee
Employee

The whole point of the trellis chart is to compare how different distributions look which would imply a common scale. And static min/max is evaluated once for the whole chart so would not give different scales.