topic Trellis Chart Grouped Expressions in QlikView https://community.qlik.com/t5/QlikView/Trellis-Chart-Grouped-Expressions/m-p/260674#M587070 <HTML><HEAD></HEAD><BODY><P>because Before function can only be used with Pivot tables, it returns null for all other chart types...so, you are not getting values for Trellis Chart....I hope it is helpful and I believe you know other ways to achieve the same output....<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 03 Jun 2011 13:34:09 GMT 2011-06-03T13:34:09Z Trellis Chart Grouped Expressions https://community.qlik.com/t5/QlikView/Trellis-Chart-Grouped-Expressions/m-p/260672#M587068 <HTML><HEAD></HEAD><BODY><P>Good Day All,</P><P></P><P>In the attached QVW example I have Purchase Receipt transactions whose cost I want to show by Item and MonthYear in a trellis chart. Additionally, I want to show the percentage change from the prior cost. The expressions are Grouped. To observe the results I made the chart a fast change between a pivot table and a bar chart.</P><P></P><P>The costs and percentage change renders correctly in the pivot table, but the percentage does not in the trellis chart.</P><P></P><P>Any thoughts on this behavior?</P><P></P><P>Thanks in advance,</P><P></P><P>Rich D</P></BODY></HTML> Thu, 02 Jun 2011 12:39:00 GMT https://community.qlik.com/t5/QlikView/Trellis-Chart-Grouped-Expressions/m-p/260672#M587068 2011-06-02T12:39:00Z Trellis Chart Grouped Expressions https://community.qlik.com/t5/QlikView/Trellis-Chart-Grouped-Expressions/m-p/260673#M587069 <HTML><HEAD></HEAD><BODY><P>Anyone encounter this? </P></BODY></HTML> Fri, 03 Jun 2011 10:58:32 GMT https://community.qlik.com/t5/QlikView/Trellis-Chart-Grouped-Expressions/m-p/260673#M587069 2011-06-03T10:58:32Z Trellis Chart Grouped Expressions https://community.qlik.com/t5/QlikView/Trellis-Chart-Grouped-Expressions/m-p/260674#M587070 <HTML><HEAD></HEAD><BODY><P>because Before function can only be used with Pivot tables, it returns null for all other chart types...so, you are not getting values for Trellis Chart....I hope it is helpful and I believe you know other ways to achieve the same output....<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 03 Jun 2011 13:34:09 GMT https://community.qlik.com/t5/QlikView/Trellis-Chart-Grouped-Expressions/m-p/260674#M587070 2011-06-03T13:34:09Z Trellis Chart Grouped Expressions https://community.qlik.com/t5/QlikView/Trellis-Chart-Grouped-Expressions/m-p/260675#M587071 <HTML><HEAD></HEAD><BODY><P> Thank you Ashutosh,</P><P></P><P>I guess it's back to the drawing board for this one.</P><P></P><P>Rich</P></BODY></HTML> Fri, 03 Jun 2011 15:14:39 GMT https://community.qlik.com/t5/QlikView/Trellis-Chart-Grouped-Expressions/m-p/260675#M587071 2011-06-03T15:14:39Z