topic Re: Complex formula with calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Complex-formula-with-calculated-dimension/m-p/415930#M154679 <HTML><HEAD></HEAD><BODY><P>I resorted to adding a summary table. A calculated dimension can't be used in a set analysis expression, so I created a new field SIMUL_NB_MAX and used that instead. See attached qvw.</P></BODY></HTML> Sat, 12 Jan 2013 12:40:43 GMT Gysbert_Wassenaar 2013-01-12T12:40:43Z Complex formula with calculated dimension https://community.qlik.com/t5/QlikView/Complex-formula-with-calculated-dimension/m-p/415929#M154678 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>herejoin is an application which is describing the formula to realize.</P><P>The only dimension is a calculated one and I just don't succeed in constructing an (complex) expression that work with it.</P><P></P><P>In the table, c<SPAN style="font-size: 8pt;"><SPAN style="font-size: 10pt;">olumn E should contain in each cell the value of column C on the yellow line (88% for PAU)</SPAN><BR /><SPAN style="font-size: 10pt;">Column F should contain in each cell the value of the sum of each green </SPAN><SPAN style="font-size: 10pt;">and yellow cell of column A (excluding values of red cells) (30 570 for PAU) </SPAN></SPAN></P><P></P><P><SPAN style="font-size: 10pt;">The constituted formula should at the end allow to draw the orange line in the graph.</SPAN></P><P></P><P><IMG __jive_id="29186" class="jive-image-thumbnail jive-image" onclick="" alt="2013-01-11_17h06_26.png" src="https://community.qlik.com/legacyfs/online/29186_2013-01-11_17h06_26.png" width="450" /></P><P>Thanks a lot for your help !</P></BODY></HTML> Fri, 11 Jan 2013 16:12:40 GMT https://community.qlik.com/t5/QlikView/Complex-formula-with-calculated-dimension/m-p/415929#M154678 2013-01-11T16:12:40Z Re: Complex formula with calculated dimension https://community.qlik.com/t5/QlikView/Complex-formula-with-calculated-dimension/m-p/415930#M154679 <HTML><HEAD></HEAD><BODY><P>I resorted to adding a summary table. A calculated dimension can't be used in a set analysis expression, so I created a new field SIMUL_NB_MAX and used that instead. See attached qvw.</P></BODY></HTML> Sat, 12 Jan 2013 12:40:43 GMT https://community.qlik.com/t5/QlikView/Complex-formula-with-calculated-dimension/m-p/415930#M154679 Gysbert_Wassenaar 2013-01-12T12:40:43Z