https://community.qlik.com/t5/App-Development/MinMax-Scaling-chart-function/m-p/1770251#M59585 <P>Hi Folks,</P><P>I'm creating a slider to enable users to select less or more relevant count of words in a word cloud. In order to have a simple understanding about the scale, I want to apply the MinMax Scaling formula in the charts:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura de tela 2020-12-23 110236.png" style="width: 249px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46088iEE9A34DF94E074BA/image-dimensions/249x82?v=v2" width="249" height="82" role="button" title="Captura de tela 2020-12-23 110236.png" alt="Captura de tela 2020-12-23 110236.png" /></span></P><P>Below I have a table with the work frequency, but I'm not getting the proper chart code to add new columns with Min(Count(feature) and Max(Count(feature) in order to have the above formula applied to a row level and considering user selection. For instance, If I select 3 words, Min and Max values should be updated to the value range available. I tried some AGGR coding, but didn't get proper results.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rrodr244_0-1608731870152.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46087i78DB8D7531B4A073/image-size/medium?v=v2&amp;px=400" role="button" title="rrodr244_0-1608731870152.png" alt="rrodr244_0-1608731870152.png" /></span></P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>Do you have some tip to help me?</P><P>Tks</P><P>Rubens</P> Sat, 16 Nov 2024 17:40:28 GMT rrodr244 2024-11-16T17:40:28Z https://community.qlik.com/t5/App-Development/MinMax-Scaling-chart-function/m-p/1770251#M59585 <P>Hi Folks,</P><P>I'm creating a slider to enable users to select less or more relevant count of words in a word cloud. In order to have a simple understanding about the scale, I want to apply the MinMax Scaling formula in the charts:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura de tela 2020-12-23 110236.png" style="width: 249px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46088iEE9A34DF94E074BA/image-dimensions/249x82?v=v2" width="249" height="82" role="button" title="Captura de tela 2020-12-23 110236.png" alt="Captura de tela 2020-12-23 110236.png" /></span></P><P>Below I have a table with the work frequency, but I'm not getting the proper chart code to add new columns with Min(Count(feature) and Max(Count(feature) in order to have the above formula applied to a row level and considering user selection. For instance, If I select 3 words, Min and Max values should be updated to the value range available. I tried some AGGR coding, but didn't get proper results.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rrodr244_0-1608731870152.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46087i78DB8D7531B4A073/image-size/medium?v=v2&amp;px=400" role="button" title="rrodr244_0-1608731870152.png" alt="rrodr244_0-1608731870152.png" /></span></P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>Do you have some tip to help me?</P><P>Tks</P><P>Rubens</P> Sat, 16 Nov 2024 17:40:28 GMT https://community.qlik.com/t5/App-Development/MinMax-Scaling-chart-function/m-p/1770251#M59585 rrodr244 2024-11-16T17:40:28Z https://community.qlik.com/t5/App-Development/MinMax-Scaling-chart-function/m-p/1770420#M59606 <P>Try this to calculate your scale calculation at a feature row level:</P><P>(count(feature)-min(Total aggr(count(feature),feature)))<BR />/(max(Total aggr(count(feature),feature))-min(Total aggr(count(feature),feature)))</P> Thu, 24 Dec 2020 11:37:46 GMT https://community.qlik.com/t5/App-Development/MinMax-Scaling-chart-function/m-p/1770420#M59606 GaryGiles 2020-12-24T11:37:46Z