topic Re: compare value based on the count _need to create bar chart in QlikView https://community.qlik.com/t5/QlikView/compare-value-based-on-the-count-need-to-create-bar-chart/m-p/641963#M235179 <HTML><HEAD></HEAD><BODY><P>Please find the below url and need same model of chart </P><P><A href="https://community.qlik.com/thread/119329">Need to create Report based on the 2 dimension</A></P></BODY></HTML> Wed, 21 May 2014 18:44:59 GMT Umesh 2014-05-21T18:44:59Z compare value based on the count _need to create bar chart https://community.qlik.com/t5/QlikView/compare-value-based-on-the-count-need-to-create-bar-chart/m-p/641960#M235176 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">NAME</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">FIELD 1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">FIELD 2</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">A</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">30</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">B</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">40</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">C</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">30</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">D</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">40</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">E</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">30</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>I need to compare the Field 1 &amp; field 2 Value counts </P><P>Eg if Field 1 have value 10, 2 time </P><P>20 value 2 times.</P><P>Field 2 40 value 2 times </P><P>Then need to create chart with compare Filed 1 &amp; Field 2 Count values </P><P>Could you please help me to write the expressions based on this </P></BODY></HTML> Wed, 21 May 2014 13:59:34 GMT https://community.qlik.com/t5/QlikView/compare-value-based-on-the-count-need-to-create-bar-chart/m-p/641960#M235176 Umesh 2014-05-21T13:59:34Z Re: compare value based on the count _need to create bar chart https://community.qlik.com/t5/QlikView/compare-value-based-on-the-count-need-to-create-bar-chart/m-p/641961#M235177 <HTML><HEAD></HEAD><BODY><P>Do you want an expression for the difference between the two fields?&nbsp; Could you please try to restate your question?</P></BODY></HTML> Wed, 21 May 2014 14:05:00 GMT https://community.qlik.com/t5/QlikView/compare-value-based-on-the-count-need-to-create-bar-chart/m-p/641961#M235177 2014-05-21T14:05:00Z Re: compare value based on the count _need to create bar chart https://community.qlik.com/t5/QlikView/compare-value-based-on-the-count-need-to-create-bar-chart/m-p/641962#M235178 <HTML><HEAD></HEAD><BODY><P>Here it is</P></BODY></HTML> Wed, 21 May 2014 14:06:51 GMT https://community.qlik.com/t5/QlikView/compare-value-based-on-the-count-need-to-create-bar-chart/m-p/641962#M235178 alexandros17 2014-05-21T14:06:51Z Re: compare value based on the count _need to create bar chart https://community.qlik.com/t5/QlikView/compare-value-based-on-the-count-need-to-create-bar-chart/m-p/641963#M235179 <HTML><HEAD></HEAD><BODY><P>Please find the below url and need same model of chart </P><P><A href="https://community.qlik.com/thread/119329">Need to create Report based on the 2 dimension</A></P></BODY></HTML> Wed, 21 May 2014 18:44:59 GMT https://community.qlik.com/t5/QlikView/compare-value-based-on-the-count-need-to-create-bar-chart/m-p/641963#M235179 Umesh 2014-05-21T18:44:59Z