topic Re: Calculate columnNo with two horizontal dims in QlikView https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451647#M434400 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Do you know how to calculate range sum in this case?</P><P style="font-size: 13.3333px;">because rangesum(before(sum(Sales),1,ColumnNo(total)-1)) returns 0 in every column.</P></BODY></HTML> Fri, 24 Nov 2017 11:42:52 GMT Anonymous 2017-11-24T11:42:52Z Calculate columnNo with two horizontal dims https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451644#M434397 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P>Did anyone have a deal with calculating column number in case when we have two dimensions in the columns?</P><P></P><P><IMG alt="CN.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/184469_CN.jpg" style="max-width: 620px; height: auto;" /></P><P></P><P>is it possible to calculate correctly number of each column? without changing the position of dims/expr.</P><P>Thanks.</P></BODY></HTML> Fri, 24 Nov 2017 11:00:54 GMT https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451644#M434397 Anonymous 2017-11-24T11:00:54Z Re: Calculate columnNo with two horizontal dims https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451645#M434398 <HTML><HEAD></HEAD><BODY><P>add total, <SPAN style="color: #0000ff; font-size: 8pt;">ColumnNo</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Fri, 24 Nov 2017 11:28:29 GMT https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451645#M434398 stabben23 2017-11-24T11:28:29Z Re: Calculate columnNo with two horizontal dims https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451646#M434399 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Fri, 24 Nov 2017 11:29:10 GMT https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451646#M434399 Anonymous 2017-11-24T11:29:10Z Re: Calculate columnNo with two horizontal dims https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451647#M434400 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Do you know how to calculate range sum in this case?</P><P style="font-size: 13.3333px;">because rangesum(before(sum(Sales),1,ColumnNo(total)-1)) returns 0 in every column.</P></BODY></HTML> Fri, 24 Nov 2017 11:42:52 GMT https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451647#M434400 Anonymous 2017-11-24T11:42:52Z Re: Calculate columnNo with two horizontal dims https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451648#M434401 <HTML><HEAD></HEAD><BODY><P>like this</P><P><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">rangesum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">),0,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">rowno</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN><SPAN style="font-size: 8pt;">))),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Fri, 24 Nov 2017 11:56:10 GMT https://community.qlik.com/t5/QlikView/Calculate-columnNo-with-two-horizontal-dims/m-p/1451648#M434401 stabben23 2017-11-24T11:56:10Z