topic Charts for comparing data in QlikView https://community.qlik.com/t5/QlikView/Charts-for-comparing-data/m-p/431064#M1157668 <HTML><HEAD></HEAD><BODY><P>I have some data in excel which has the Person Name,Package Name,Region Name and Date of Change.</P><P>So I wanted a chart which will tell me how many person have changed thier packages in a specified region. Is it possible in qlikview?</P><P></P><P>The Packages would be like "Gold or Platinum or Basic" The region can be like "BTM,Whitefield etc"</P><P></P><P>So the data would like below,</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Person Name</STRONG><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Package Name<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Region Name<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Date of Change<BR /></TH></TR><TR><TD>Person A</TD><TD>Basic</TD><TD>BTM</TD><TD>1/1/2013</TD></TR><TR><TD>Person B</TD><TD>Gold</TD><TD>Whitefield</TD><TD>1/2/2013</TD></TR><TR><TD>Person A</TD><TD>Gold</TD><TD>BTM</TD><TD>2/2/2013</TD></TR><TR><TD>Person B</TD><TD>Basic</TD><TD>Whitefield</TD><TD>2/3/2013</TD></TR></TBODY></TABLE><P>As per above data I would want a chart which would dynamically tell me how many people in Whitefield / BTM have changed from Basic package to gold or gold to platinum. But if some one changes from Platiunum to gold or gold to basic or platinum to basic it should show it some kind of negative way in the bar chart or some other chart. Is it possible in Qlikview?</P></BODY></HTML> Wed, 13 Feb 2013 06:55:24 GMT 2013-02-13T06:55:24Z Charts for comparing data https://community.qlik.com/t5/QlikView/Charts-for-comparing-data/m-p/431064#M1157668 <HTML><HEAD></HEAD><BODY><P>I have some data in excel which has the Person Name,Package Name,Region Name and Date of Change.</P><P>So I wanted a chart which will tell me how many person have changed thier packages in a specified region. Is it possible in qlikview?</P><P></P><P>The Packages would be like "Gold or Platinum or Basic" The region can be like "BTM,Whitefield etc"</P><P></P><P>So the data would like below,</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Person Name</STRONG><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Package Name<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Region Name<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Date of Change<BR /></TH></TR><TR><TD>Person A</TD><TD>Basic</TD><TD>BTM</TD><TD>1/1/2013</TD></TR><TR><TD>Person B</TD><TD>Gold</TD><TD>Whitefield</TD><TD>1/2/2013</TD></TR><TR><TD>Person A</TD><TD>Gold</TD><TD>BTM</TD><TD>2/2/2013</TD></TR><TR><TD>Person B</TD><TD>Basic</TD><TD>Whitefield</TD><TD>2/3/2013</TD></TR></TBODY></TABLE><P>As per above data I would want a chart which would dynamically tell me how many people in Whitefield / BTM have changed from Basic package to gold or gold to platinum. But if some one changes from Platiunum to gold or gold to basic or platinum to basic it should show it some kind of negative way in the bar chart or some other chart. Is it possible in Qlikview?</P></BODY></HTML> Wed, 13 Feb 2013 06:55:24 GMT https://community.qlik.com/t5/QlikView/Charts-for-comparing-data/m-p/431064#M1157668 2013-02-13T06:55:24Z