topic Re: A problem that needs solving in QlikView https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829490#M1018218 <HTML><HEAD></HEAD><BODY><P>Thanks for your help, Rubin. That works but visually it has not turned out like I envisaged as the difference between the greatest line of business and the smallest line of business is a big amount. Is there any way i can make this information more visually appealing.</P><P></P><P>Thanks,</P><P>Stephen</P></BODY></HTML> Tue, 31 Mar 2015 14:59:37 GMT 2015-03-31T14:59:37Z A problem that needs solving https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829485#M1018213 <HTML><HEAD></HEAD><BODY><P>How do I create a trend line showing the year the policy was created for each sector of the line of business.</P><P>I have created a graph in the sales growth tab but for the life of me am not able to get it to show what I am asking above.</P><P>If any can provide a help, I would greatly appreciate it.</P></BODY></HTML> Tue, 31 Mar 2015 14:24:07 GMT https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829485#M1018213 2015-03-31T14:24:07Z Re: A problem that needs solving https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829486#M1018214 <HTML><HEAD></HEAD><BODY><P>Hi Stephen, if you add Line of Business as second dimension doesn't give you the desired result?</P><P>Wich results are you expecting?</P></BODY></HTML> Tue, 31 Mar 2015 14:39:09 GMT https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829486#M1018214 rubenmarin 2015-03-31T14:39:09Z Re: A problem that needs solving https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829487#M1018215 <HTML><HEAD></HEAD><BODY><P>Hi Ruben,</P><P></P><P>What i planned to show was trend line for the years 2001, 2002 etc for each of the 4 lines of business, health, commercial etc. So my line graph should show 4 different trend lines for each of the years. I have been trying to do this for ages, it is really frustrating me and as I am new to qlikview I dont know if this is possible. If this is not possible could you suggest something else.</P><P></P><P>Thanks,</P><P>Stephen</P></BODY></HTML> Tue, 31 Mar 2015 14:46:29 GMT https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829487#M1018215 2015-03-31T14:46:29Z Re: A problem that needs solving https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829488#M1018216 <HTML><HEAD></HEAD><BODY><P>Hi, if I understand it right you only need to add Line of Business as dimension, please check attachment</P></BODY></HTML> Tue, 31 Mar 2015 14:49:22 GMT https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829488#M1018216 rubenmarin 2015-03-31T14:49:22Z Re: A problem that needs solving https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829489#M1018217 <HTML><HEAD></HEAD><BODY><P>If you do what Ruben says it´s working. You will have a trend line for each line of business</P></BODY></HTML> Tue, 31 Mar 2015 14:50:27 GMT https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829489#M1018217 fvelascog72 2015-03-31T14:50:27Z Re: A problem that needs solving https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829490#M1018218 <HTML><HEAD></HEAD><BODY><P>Thanks for your help, Rubin. That works but visually it has not turned out like I envisaged as the difference between the greatest line of business and the smallest line of business is a big amount. Is there any way i can make this information more visually appealing.</P><P></P><P>Thanks,</P><P>Stephen</P></BODY></HTML> Tue, 31 Mar 2015 14:59:37 GMT https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829490#M1018218 2015-03-31T14:59:37Z Re: A problem that needs solving https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829491#M1018219 <HTML><HEAD></HEAD><BODY><P>It's difficult when there are a big difference between one business line and others, maybe in axis tab checking logarithm scale but those graphs are hard to read.</P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82527_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 31 Mar 2015 15:19:22 GMT https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829491#M1018219 rubenmarin 2015-03-31T15:19:22Z Re: A problem that needs solving https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829492#M1018220 <HTML><HEAD></HEAD><BODY><P>Thanks Ruben</P></BODY></HTML> Tue, 31 Mar 2015 15:47:24 GMT https://community.qlik.com/t5/QlikView/A-problem-that-needs-solving/m-p/829492#M1018220 2015-03-31T15:47:24Z