https://community.qlik.com/t5/App-Development/Problem-Dimension-Pivot-Tablet/m-p/1564578#M41112 <P>I Create variable and used the&nbsp; function&nbsp;<STRONG>=GetObjectField(0)</STRONG>,&nbsp;<SPAN>to get the dimensions.</SPAN></P><P><SPAN>Then applied the variables in the calculations.</SPAN></P><P><STRONG>IF(Dimensionality()=1, Fractile(Aggr(Sum([core_hs_simulation.value]),[core_hs_scenarios.scenario_date],$(vDim0)),0.01),</STRONG></P><P><SPAN>Now I can dynamically group by the selected dimension.</SPAN></P><P>&nbsp;</P> Wed, 03 Apr 2019 12:56:30 GMT quinsan12 2019-04-03T12:56:30Z https://community.qlik.com/t5/App-Development/Problem-Dimension-Pivot-Tablet/m-p/1564116#M41069 <P><FONT face="arial,helvetica,sans-serif"><STRONG>I need to perform the calculation below, in the pivot table automatically following the hierarchy of the dimension. That is, in the first line add by dimension one and so on.</STRONG></FONT></P><P><FONT face="arial,helvetica,sans-serif">IF(Dimensionality()=1, Fractile(Aggr(Sum([core_hs_simulation.value]),[core_hs_scenarios.scenario_date], <STRONG>DIM1</STRONG>),0.01),</FONT></P><P><BR /><FONT face="arial,helvetica,sans-serif">IF(Dimensionality()=2, Fractile(Aggr(Sum([core_hs_simulation.value]),[core_hs_scenarios.scenario_date], <STRONG>DIM1,DIM2</STRONG>),0.01),</FONT></P><P><BR /><FONT face="arial,helvetica,sans-serif">IF(Dimensionality()=3, Fractile(Aggr(Sum([core_hs_simulation.value]),[core_hs_scenarios.scenario_date],<STRONG>DIM1,DIM2,DIM3</STRONG>),0.01)</FONT><BR />)))</P> Tue, 02 Apr 2019 16:47:14 GMT https://community.qlik.com/t5/App-Development/Problem-Dimension-Pivot-Tablet/m-p/1564116#M41069 quinsan12 2019-04-02T16:47:14Z https://community.qlik.com/t5/App-Development/Problem-Dimension-Pivot-Tablet/m-p/1564578#M41112 <P>I Create variable and used the&nbsp; function&nbsp;<STRONG>=GetObjectField(0)</STRONG>,&nbsp;<SPAN>to get the dimensions.</SPAN></P><P><SPAN>Then applied the variables in the calculations.</SPAN></P><P><STRONG>IF(Dimensionality()=1, Fractile(Aggr(Sum([core_hs_simulation.value]),[core_hs_scenarios.scenario_date],$(vDim0)),0.01),</STRONG></P><P><SPAN>Now I can dynamically group by the selected dimension.</SPAN></P><P>&nbsp;</P> Wed, 03 Apr 2019 12:56:30 GMT https://community.qlik.com/t5/App-Development/Problem-Dimension-Pivot-Tablet/m-p/1564578#M41112 quinsan12 2019-04-03T12:56:30Z