topic Dynamic Scale in Trellis Chart in QlikView

Dynamic Scale in Trellis Chart

Thu, 07 Oct 2010 10:14:06 GMT

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

Dynamic Scale in Trellis Chart

Thu, 07 Oct 2010 12:17:06 GMT

Try setting the static max of the axes using

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

Dynamic Scale in Trellis Chart

Thu, 07 Oct 2010 12:23:49 GMT

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)))

Dynamic Scale in Trellis Chart

kji — Thu, 07 Oct 2010 12:24:18 GMT

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.