topic Re: Select Value Range to Show in Pivot Chart Expression in QlikView https://community.qlik.com/t5/QlikView/Select-Value-Range-to-Show-in-Pivot-Chart-Expression/m-p/384142#M1168057 <HTML><HEAD></HEAD><BODY><P>Use calculated dimensions (and set analysis if needed):</P><P>=If(YourValueRangeCheck, YourDimension, null())</P></BODY></HTML> Wed, 05 Sep 2012 08:45:19 GMT whiteline 2012-09-05T08:45:19Z Select Value Range to Show in Pivot Chart Expression https://community.qlik.com/t5/QlikView/Select-Value-Range-to-Show-in-Pivot-Chart-Expression/m-p/384141#M1168056 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>As in a <SPAN style="color: #0000ff;">straight table</SPAN>, I can use <STRONG style="color: #339966;">dimension limit tab</STRONG> to define the value range that I want to show in the expressions.</P><P></P><P>However, in a <SPAN style="color: #800080;">pivot table</SPAN>, the <STRONG style="color: #339966;">dimension limit tab</STRONG> just disappears. Can I know is there a similar solution to pivot table? (besides doing it in SQL)</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 05 Sep 2012 02:27:09 GMT https://community.qlik.com/t5/QlikView/Select-Value-Range-to-Show-in-Pivot-Chart-Expression/m-p/384141#M1168056 2012-09-05T02:27:09Z Re: Select Value Range to Show in Pivot Chart Expression https://community.qlik.com/t5/QlikView/Select-Value-Range-to-Show-in-Pivot-Chart-Expression/m-p/384142#M1168057 <HTML><HEAD></HEAD><BODY><P>Use calculated dimensions (and set analysis if needed):</P><P>=If(YourValueRangeCheck, YourDimension, null())</P></BODY></HTML> Wed, 05 Sep 2012 08:45:19 GMT https://community.qlik.com/t5/QlikView/Select-Value-Range-to-Show-in-Pivot-Chart-Expression/m-p/384142#M1168057 whiteline 2012-09-05T08:45:19Z