topic Re: QlikView app development in QlikView https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406660#M425892 <HTML><HEAD></HEAD><BODY><P>Your .pptx indicates you are looking for Min, Avg and Max values by Month. If so, simply change the Sum(Healthy) to Min(Healthy), Avg(Healthy) and Max(Healthy). (do the same for Challenge, Danger and Trending)</P><P></P><P>Else, what is it you are trying to do?</P></BODY></HTML> Fri, 01 Dec 2017 18:43:26 GMT johnca 2017-12-01T18:43:26Z QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406651#M425883 <HTML><HEAD></HEAD><BODY><P>I have the data in the attached XLS and i want to distribute the data based on. PPT attached. Can any one help me.I have pointed two rows in the PPT</P><P></P><P>Thanks in advance. </P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin: auto auto auto -1.15pt;" width="887"><TBODY><TR><TD nowrap="nowrap" style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="bottom" width="69"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Challenge</SPAN></P></TD><TD nowrap="nowrap" style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="bottom" width="51"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Danger</SPAN></P></TD><TD nowrap="nowrap" style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="bottom" width="55"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Healthy</SPAN></P></TD><TD nowrap="nowrap" style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="bottom" width="63"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Trending</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Thu, 30 Nov 2017 16:24:01 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406651#M425883 Anonymous 2017-11-30T16:24:01Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406652#M425884 <HTML><HEAD></HEAD><BODY><P>can anyone help me please?</P><P>Thanks in advance.</P></BODY></HTML> Fri, 01 Dec 2017 08:06:57 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406652#M425884 Anonymous 2017-12-01T08:06:57Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406653#M425885 <HTML><HEAD></HEAD><BODY><P>What has this to do with Qlikview or Qlik Sense?</P></BODY></HTML> Fri, 01 Dec 2017 08:27:08 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406653#M425885 jonathandienst 2017-12-01T08:27:08Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406654#M425886 <HTML><HEAD></HEAD><BODY><P>QlikView only.</P><P></P><P>Thanks for your response.</P></BODY></HTML> Fri, 01 Dec 2017 08:33:10 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406654#M425886 Anonymous 2017-12-01T08:33:10Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406655#M425887 <HTML><HEAD></HEAD><BODY><P>can we change the data structure or not ?&nbsp; in excel you provided</P></BODY></HTML> Fri, 01 Dec 2017 08:49:46 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406655#M425887 woshua5550 2017-12-01T08:49:46Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406656#M425888 <HTML><HEAD></HEAD><BODY><P>sure</P></BODY></HTML> Fri, 01 Dec 2017 11:00:20 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406656#M425888 Anonymous 2017-12-01T11:00:20Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406657#M425889 <HTML><HEAD></HEAD><BODY><P>do you mean like this ? a draft version attached</P></BODY></HTML> Fri, 01 Dec 2017 11:42:35 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406657#M425889 woshua5550 2017-12-01T11:42:35Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406658#M425890 <HTML><HEAD></HEAD><BODY><P>Thanks for your proactive effort. Appreciate it. If you notice the value has changed to 150%. Which is wrong. Any suggestion?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/185412_Capture.PNG" style="height: 393px; width: 620px;" /></P></BODY></HTML> Fri, 01 Dec 2017 13:19:40 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406658#M425890 Anonymous 2017-12-01T13:19:40Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406659#M425891 <HTML><HEAD></HEAD><BODY><P>Did you get my point?</P></BODY></HTML> Fri, 01 Dec 2017 18:10:35 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406659#M425891 Anonymous 2017-12-01T18:10:35Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406660#M425892 <HTML><HEAD></HEAD><BODY><P>Your .pptx indicates you are looking for Min, Avg and Max values by Month. If so, simply change the Sum(Healthy) to Min(Healthy), Avg(Healthy) and Max(Healthy). (do the same for Challenge, Danger and Trending)</P><P></P><P>Else, what is it you are trying to do?</P></BODY></HTML> Fri, 01 Dec 2017 18:43:26 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406660#M425892 johnca 2017-12-01T18:43:26Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406661#M425893 <HTML><HEAD></HEAD><BODY><P>yes ..you are right friend</P></BODY></HTML> Sat, 02 Dec 2017 03:30:20 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406661#M425893 Anonymous 2017-12-02T03:30:20Z Re: QlikView app development https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406662#M425894 <HTML><HEAD></HEAD><BODY><P>Then it looks like Dave Lau had you pointed in the right direction. As he asked, you should also try to get the data file in a better format. Merged cells/rows are no fun.</P><P></P><P>For each chart dimension use Date(Date,'MMM-YYYY') to get the format you displayed a la "Mar-2017", et al.</P><P></P><P>Each chart should have 3 expressions:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Min(Healthy)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Avg(Healthy)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Max(Healthy)</P><P></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Min(Challenge)</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Avg(<SPAN style="font-size: 13.3333px;">Challenge</SPAN>)</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Max(<SPAN style="font-size: 13.3333px;">Challenge</SPAN>)</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Min(Danger)</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Avg(<SPAN style="font-size: 13.3333px;">Danger</SPAN>)</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Max(<SPAN style="font-size: 13.3333px;">Danger</SPAN>)</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Min(Trending)</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Avg(<SPAN style="font-size: 13.3333px;">Trending</SPAN>)</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Max(<SPAN style="font-size: 13.3333px;">Trending</SPAN>)</P></BODY></HTML> Sat, 02 Dec 2017 22:49:01 GMT https://community.qlik.com/t5/QlikView/QlikView-app-development/m-p/1406662#M425894 johnca 2017-12-02T22:49:01Z