topic YTD problems - already checked out 10 examples... in QlikView https://community.qlik.com/t5/QlikView/YTD-problems-already-checked-out-10-examples/m-p/178616#M501845 <HTML><HEAD></HEAD><BODY><P>Try the following function in your pivot table</P><P>rangesum(before(sum(OMZET),0,12))</P><P>Set analysis doesn't work when the set anaylsis is done over fields that are defined as dimensions.</P><P>Regards.</P></BODY></HTML> Tue, 09 Nov 2010 16:10:41 GMT pover 2010-11-09T16:10:41Z YTD problems - already checked out 10 examples... https://community.qlik.com/t5/QlikView/YTD-problems-already-checked-out-10-examples/m-p/178615#M501844 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have tried all the options and I had a few successes with this, but unfortunately I can't find the answer to my problem.</P><P>I am trying to make a chart with YTD (In PIVOT table layout). However, the functions do not work properly. Whichever one I try</P><P>See attached example</P><P></P><P>Thanks in advance for your help!</P></BODY></HTML> Tue, 09 Nov 2010 15:57:32 GMT https://community.qlik.com/t5/QlikView/YTD-problems-already-checked-out-10-examples/m-p/178615#M501844 2010-11-09T15:57:32Z YTD problems - already checked out 10 examples... https://community.qlik.com/t5/QlikView/YTD-problems-already-checked-out-10-examples/m-p/178616#M501845 <HTML><HEAD></HEAD><BODY><P>Try the following function in your pivot table</P><P>rangesum(before(sum(OMZET),0,12))</P><P>Set analysis doesn't work when the set anaylsis is done over fields that are defined as dimensions.</P><P>Regards.</P></BODY></HTML> Tue, 09 Nov 2010 16:10:41 GMT https://community.qlik.com/t5/QlikView/YTD-problems-already-checked-out-10-examples/m-p/178616#M501845 pover 2010-11-09T16:10:41Z YTD problems - already checked out 10 examples... https://community.qlik.com/t5/QlikView/YTD-problems-already-checked-out-10-examples/m-p/178617#M501846 <HTML><HEAD></HEAD><BODY><P>PERFECT !!! I think this will work!</P></BODY></HTML> Tue, 09 Nov 2010 16:21:27 GMT https://community.qlik.com/t5/QlikView/YTD-problems-already-checked-out-10-examples/m-p/178617#M501846 2010-11-09T16:21:27Z