topic Re: Same value appearing for all the Rows in QlikView https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324014#M834254 <HTML><HEAD></HEAD><BODY><P>Ok whats the number your excepting ? could you show the values for each month </P></BODY></HTML> Wed, 07 Jun 2017 07:24:02 GMT avinashelite 2017-06-07T07:24:02Z Same value appearing for all the Rows https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324011#M834248 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have created a simple Straight table.. My Total value is showing right and When i click on one particular Reporting month, still the numbers are fine. Problem arises when i click on couple of months or more than that... It shows the same value for all the reporting month.. Not sure where i need to tweak.. I have created with few Variables.. and have demonstrated clearly.. Please help me to get the right values for each and every Reporting month..Attached files FYR..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324011#M834248 bharani8 2020-11-25T16:16:04Z Re: Same value appearing for all the Rows https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324012#M834249 <HTML><HEAD></HEAD><BODY><P><EM>Hi </EM></P><P><EM>try this expression and let me know if it gives the rite results </EM></P><P><EM>=(Fractile(sotat,.9)-1+(Count(SCHEDULE_LOGIC)*.9+count({&lt;sotat = {"=(Fractile(sotat,.9))"}&gt;} SCHEDULE_LOGIC)))/count({&lt;sotat = {"=(Fractile(sotat,.9))"}&gt;} SCHEDULE_LOGIC)</EM></P></BODY></HTML> Wed, 07 Jun 2017 07:01:40 GMT https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324012#M834249 avinashelite 2017-06-07T07:01:40Z Re: Same value appearing for all the Rows https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324013#M834251 <HTML><HEAD></HEAD><BODY><P>I See different numbers.. But result is wrong for all the months .. Even Total is wrong <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 07 Jun 2017 07:04:13 GMT https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324013#M834251 bharani8 2017-06-07T07:04:13Z Re: Same value appearing for all the Rows https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324014#M834254 <HTML><HEAD></HEAD><BODY><P>Ok whats the number your excepting ? could you show the values for each month </P></BODY></HTML> Wed, 07 Jun 2017 07:24:02 GMT https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324014#M834254 avinashelite 2017-06-07T07:24:02Z Re: Same value appearing for all the Rows https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324015#M834256 <HTML><HEAD></HEAD><BODY><P>Nov - 1.83</P><P>Dec - 1.91</P><P>Jan - 2.71</P><P>Total - 2.03</P></BODY></HTML> Wed, 07 Jun 2017 07:29:04 GMT https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324015#M834256 bharani8 2017-06-07T07:29:04Z Re: Same value appearing for all the Rows https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324016#M834258 <HTML><HEAD></HEAD><BODY><P>Any luck Avinash ?</P></BODY></HTML> Thu, 08 Jun 2017 05:47:22 GMT https://community.qlik.com/t5/QlikView/Same-value-appearing-for-all-the-Rows/m-p/1324016#M834258 bharani8 2017-06-08T05:47:22Z