topic synthetic Dimension with calculated values in QlikView https://community.qlik.com/t5/QlikView/synthetic-Dimension-with-calculated-values/m-p/267655#M583112 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>it is possible to create a chart with a calculated dimension?</P><P></P><P>Data:</P><P>[ Orgname, .......... ,Tax-Number </P><P> 'A', ......, null </P><P> 'B', ......, 123</P><P> 'C, ......., 111</P><P> 'D', ......, null ]</P><P></P><P>I want a pie chart with to values </P><P>- count of Orgname with a taxnumber</P><P>- count of Orgname without a taxnumber</P><P>and without a calculated field from the script</P><P></P><P>best regards</P></BODY></HTML> Wed, 30 Nov 2011 09:34:25 GMT 2011-11-30T09:34:25Z synthetic Dimension with calculated values https://community.qlik.com/t5/QlikView/synthetic-Dimension-with-calculated-values/m-p/267655#M583112 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>it is possible to create a chart with a calculated dimension?</P><P></P><P>Data:</P><P>[ Orgname, .......... ,Tax-Number </P><P> 'A', ......, null </P><P> 'B', ......, 123</P><P> 'C, ......., 111</P><P> 'D', ......, null ]</P><P></P><P>I want a pie chart with to values </P><P>- count of Orgname with a taxnumber</P><P>- count of Orgname without a taxnumber</P><P>and without a calculated field from the script</P><P></P><P>best regards</P></BODY></HTML> Wed, 30 Nov 2011 09:34:25 GMT https://community.qlik.com/t5/QlikView/synthetic-Dimension-with-calculated-values/m-p/267655#M583112 2011-11-30T09:34:25Z Re: synthetic Dimension with calculated values https://community.qlik.com/t5/QlikView/synthetic-Dimension-with-calculated-values/m-p/267656#M583113 <HTML><HEAD></HEAD><BODY><P>Yes Bauern its possible. </P><P></P><P>Use the below code in pie chart: dimension and expression respectively.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>=If(isnull(Tax-Number),'Without Tax Number','Tax Number')</P><P>=count(Distinct Orgname)</P></PRE><P></P><P>Regards,</P><P>Kiran.</P></BODY></HTML> Wed, 30 Nov 2011 09:53:20 GMT https://community.qlik.com/t5/QlikView/synthetic-Dimension-with-calculated-values/m-p/267656#M583113 2011-11-30T09:53:20Z synthetic Dimension with calculated values https://community.qlik.com/t5/QlikView/synthetic-Dimension-with-calculated-values/m-p/267657#M583119 <HTML><HEAD></HEAD><BODY><P>perfect...... thank you</P></BODY></HTML> Wed, 30 Nov 2011 10:08:27 GMT https://community.qlik.com/t5/QlikView/synthetic-Dimension-with-calculated-values/m-p/267657#M583119 2011-11-30T10:08:27Z