topic Chart dimensions in QlikView https://community.qlik.com/t5/QlikView/Chart-dimensions/m-p/938629#M527379 <HTML><HEAD></HEAD><BODY><P>I have 3 tables automatically joined in one fact table because all of them have the same fields (quantity, type and value)</P><P>Imagine this tables are product1, product2 and estimate.</P><P>I want to make chart that compares the value of product1+product2 with estimate in the dimensions...</P><P>Thank you in advance for any help you can give me.</P></BODY></HTML> Wed, 21 Oct 2015 14:07:59 GMT slribeiro 2015-10-21T14:07:59Z Chart dimensions https://community.qlik.com/t5/QlikView/Chart-dimensions/m-p/938629#M527379 <HTML><HEAD></HEAD><BODY><P>I have 3 tables automatically joined in one fact table because all of them have the same fields (quantity, type and value)</P><P>Imagine this tables are product1, product2 and estimate.</P><P>I want to make chart that compares the value of product1+product2 with estimate in the dimensions...</P><P>Thank you in advance for any help you can give me.</P></BODY></HTML> Wed, 21 Oct 2015 14:07:59 GMT https://community.qlik.com/t5/QlikView/Chart-dimensions/m-p/938629#M527379 slribeiro 2015-10-21T14:07:59Z Re: Chart dimensions https://community.qlik.com/t5/QlikView/Chart-dimensions/m-p/938630#M527380 <HTML><HEAD></HEAD><BODY><P>Perhaps an expression like rangesum(sum({&lt;Type={'product1'}&gt;}value), sum(<SPAN style="font-size: 13.3333px;">{&lt;Type={'product2'}&gt;}</SPAN>value), -sum(<SPAN style="font-size: 13.3333px;">{&lt;Type={'estimate'}&gt;}</SPAN>value))</P></BODY></HTML> Fri, 23 Oct 2015 12:44:26 GMT https://community.qlik.com/t5/QlikView/Chart-dimensions/m-p/938630#M527380 Gysbert_Wassenaar 2015-10-23T12:44:26Z