topic Help needed creating a trending chart in QlikView https://community.qlik.com/t5/QlikView/Help-needed-creating-a-trending-chart/m-p/1053848#M353433 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have the following data:</P><P></P><P><IMG __jive_id="113609" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113609_Capture.JPG" style="height: 105px; width: 620px;" /></P><P>and I would like to have it displayed like this:</P><P></P><P><IMG __jive_id="113610" alt="Untitled.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/113610_Untitled.png" style="height: auto;" /></P><P></P><P>You know: rating on the left, timeline below and the trending. I want to show the changes of rating over time. I tried to create a trend chart but don't know what dimmensions and expressions to use. Please take into consideration there is a long list of clients. Probably all lines will be showed in the same chart, but that's ok. </P><P></P><P>Thanks for any help provided.</P></BODY></HTML> Thu, 04 Feb 2016 17:56:45 GMT 2016-02-04T17:56:45Z Help needed creating a trending chart https://community.qlik.com/t5/QlikView/Help-needed-creating-a-trending-chart/m-p/1053848#M353433 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have the following data:</P><P></P><P><IMG __jive_id="113609" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113609_Capture.JPG" style="height: 105px; width: 620px;" /></P><P>and I would like to have it displayed like this:</P><P></P><P><IMG __jive_id="113610" alt="Untitled.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/113610_Untitled.png" style="height: auto;" /></P><P></P><P>You know: rating on the left, timeline below and the trending. I want to show the changes of rating over time. I tried to create a trend chart but don't know what dimmensions and expressions to use. Please take into consideration there is a long list of clients. Probably all lines will be showed in the same chart, but that's ok. </P><P></P><P>Thanks for any help provided.</P></BODY></HTML> Thu, 04 Feb 2016 17:56:45 GMT https://community.qlik.com/t5/QlikView/Help-needed-creating-a-trending-chart/m-p/1053848#M353433 2016-02-04T17:56:45Z Re: Help needed creating a trending chart https://community.qlik.com/t5/QlikView/Help-needed-creating-a-trending-chart/m-p/1053849#M353434 <HTML><HEAD></HEAD><BODY><P>Something like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113643_Capture.PNG" style="max-width: 620px; height: auto;" /></P><P></P><P>Dimension: <STRONG>reporting_date2</STRONG></P><P>Expression: <STRONG>=Match(rating, 'Red', 'Yellow', 'Green')</STRONG></P></BODY></HTML> Fri, 05 Feb 2016 02:10:01 GMT https://community.qlik.com/t5/QlikView/Help-needed-creating-a-trending-chart/m-p/1053849#M353434 sunny_talwar 2016-02-05T02:10:01Z