topic Dashboard Question in QlikView https://community.qlik.com/t5/QlikView/Dashboard-Question/m-p/111170#M750772 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P>I have requirement to create dashboard in QlikView based on the following logic:</P><P>I have attached sample data, Expected dashboard in QlikView (something similar) and scores dashboard. So in the sample data the columns of interest are:</P><UL><LI>Issue Priority and filtered<UL><LI>Major</LI><LI>Limited</LI></UL></LI><LI>Issue Status<UL><LI>On track</LI><LI>Pipeline</LI><LI>Awaiting validation</LI></UL></LI><LI>Due by Category<UL><LI>within 30 days</LI></UL></LI></UL><P>So (This is based on Scores dashboard)</P><UL><LI>I want to calculate the Total Major issues score for On track and Pipeline (within 30 days)<UL><LI>&lt;10%&nbsp; major issues then score=7 or if 10-20% then score =10 or if &gt;21% major issues then score =14</LI></UL></LI><LI>Similarly for the Total limited issues score for On track and pipeline( within 30 days)<UL><LI>if&gt;90% Limited issues then score =5 or 80-89% limited issues then score =8 or if &lt;79% then score =12</LI></UL></LI><LI>For Total issues AIV( Awaiting validation)<UL><LI>&gt;70% of issues AIV then score = 2 if 20-69% issues AIV then score = 3 of if &lt; 20% then score =5</LI></UL></LI></UL><P>My requirement is to produce&nbsp; the Expected Dashboard in QlikView.</P><P></P><P>Your assistance will be highly appreciated.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT zwyne 2020-11-25T16:16:04Z Dashboard Question https://community.qlik.com/t5/QlikView/Dashboard-Question/m-p/111170#M750772 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P>I have requirement to create dashboard in QlikView based on the following logic:</P><P>I have attached sample data, Expected dashboard in QlikView (something similar) and scores dashboard. So in the sample data the columns of interest are:</P><UL><LI>Issue Priority and filtered<UL><LI>Major</LI><LI>Limited</LI></UL></LI><LI>Issue Status<UL><LI>On track</LI><LI>Pipeline</LI><LI>Awaiting validation</LI></UL></LI><LI>Due by Category<UL><LI>within 30 days</LI></UL></LI></UL><P>So (This is based on Scores dashboard)</P><UL><LI>I want to calculate the Total Major issues score for On track and Pipeline (within 30 days)<UL><LI>&lt;10%&nbsp; major issues then score=7 or if 10-20% then score =10 or if &gt;21% major issues then score =14</LI></UL></LI><LI>Similarly for the Total limited issues score for On track and pipeline( within 30 days)<UL><LI>if&gt;90% Limited issues then score =5 or 80-89% limited issues then score =8 or if &lt;79% then score =12</LI></UL></LI><LI>For Total issues AIV( Awaiting validation)<UL><LI>&gt;70% of issues AIV then score = 2 if 20-69% issues AIV then score = 3 of if &lt; 20% then score =5</LI></UL></LI></UL><P>My requirement is to produce&nbsp; the Expected Dashboard in QlikView.</P><P></P><P>Your assistance will be highly appreciated.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Dashboard-Question/m-p/111170#M750772 zwyne 2020-11-25T16:16:04Z Re: Dashboard Question https://community.qlik.com/t5/QlikView/Dashboard-Question/m-p/1520882#M750773 <P>And your question is?</P> Fri, 14 Dec 2018 09:02:18 GMT https://community.qlik.com/t5/QlikView/Dashboard-Question/m-p/1520882#M750773 Michiel_QV_Fan 2018-12-14T09:02:18Z