topic Re: chart calculation in QlikView https://community.qlik.com/t5/QlikView/chart-calculation/m-p/531458#M684690 <HTML><HEAD></HEAD><BODY><P>You can easily make a Flag Field in the script.</P><P></P><P><SPAN style="color: #0000ff;">IF(</SPAN><SPAN style="color: #ff0000;">Market</SPAN> = 'music' , 1 , 0)&nbsp; <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #ff0000;">_musicflag</SPAN></P><P></P><P>Then you can use <SPAN style="color: #ff0000;">_musicflag</SPAN> as your dimension in the chart.</P></BODY></HTML> Sat, 18 Jan 2014 04:45:48 GMT Anonymous 2014-01-18T04:45:48Z chart calculation https://community.qlik.com/t5/QlikView/chart-calculation/m-p/531455#M684687 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>from the table below i want to make a chart so for every country if the 'music' info exists the chart bar display 1 else 0</P><P></P><TABLE cellpadding="0" cellspacing="0" class="t1"><TBODY><TR><TD class="td1" valign="middle"><P class="p1"><STRONG>Country</STRONG></P></TD><TD class="td1" valign="middle"><P class="p1"><STRONG>Market</STRONG></P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">France</P></TD><TD class="td2" valign="middle"><P class="p1">video games</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">France</P></TD><TD class="td2" valign="middle"><P class="p1">music</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">France</P></TD><TD class="td2" valign="middle"><P class="p1">books</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">France</P></TD><TD class="td2" valign="middle"><P class="p1">tourisme</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">Spain</P></TD><TD class="td2" valign="middle"><P class="p1">books</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">Spain</P></TD><TD class="td2" valign="middle"><P class="p1">tourisme</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">Deutch</P></TD><TD class="td2" valign="middle"><P class="p1">video games</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">Deutch</P></TD><TD class="td2" valign="middle"><P class="p1">music</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">Deutch</P></TD><TD class="td2" valign="middle"><P class="p1">books</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">Deutch</P></TD><TD class="td2" valign="middle"><P class="p1">tourisme</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">Deutch</P></TD><TD class="td2" valign="middle"><P class="p1">cars</P></TD></TR><TR><TD class="td2" valign="middle"><P class="p1">Deutch</P></TD><TD class="td2" valign="middle"><P class="p1">job</P></TD></TR></TBODY></TABLE><P></P><P>thanks</P></BODY></HTML> Fri, 17 Jan 2014 23:03:45 GMT https://community.qlik.com/t5/QlikView/chart-calculation/m-p/531455#M684687 mambi 2014-01-17T23:03:45Z Re: chart calculation https://community.qlik.com/t5/QlikView/chart-calculation/m-p/531456#M684688 <HTML><HEAD></HEAD><BODY><P>Please find the attached file</P></BODY></HTML> Sat, 18 Jan 2014 01:12:14 GMT https://community.qlik.com/t5/QlikView/chart-calculation/m-p/531456#M684688 2014-01-18T01:12:14Z Re: chart calculation https://community.qlik.com/t5/QlikView/chart-calculation/m-p/531457#M684689 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA</P></BODY></HTML> Sat, 18 Jan 2014 01:16:32 GMT https://community.qlik.com/t5/QlikView/chart-calculation/m-p/531457#M684689 MayilVahanan 2014-01-18T01:16:32Z Re: chart calculation https://community.qlik.com/t5/QlikView/chart-calculation/m-p/531458#M684690 <HTML><HEAD></HEAD><BODY><P>You can easily make a Flag Field in the script.</P><P></P><P><SPAN style="color: #0000ff;">IF(</SPAN><SPAN style="color: #ff0000;">Market</SPAN> = 'music' , 1 , 0)&nbsp; <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #ff0000;">_musicflag</SPAN></P><P></P><P>Then you can use <SPAN style="color: #ff0000;">_musicflag</SPAN> as your dimension in the chart.</P></BODY></HTML> Sat, 18 Jan 2014 04:45:48 GMT https://community.qlik.com/t5/QlikView/chart-calculation/m-p/531458#M684690 Anonymous 2014-01-18T04:45:48Z