topic Set Analysis expression for 1 year data in Bar graph in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-expression-for-1-year-data-in-Bar-graph/m-p/270657#M583667 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I need to view 1year data based on the selction i do in the month field which has data (Jan - Dec) .. Let me explain it clearly.. I have some 4years data in my application.. If I select sep 2011 in the month-Year field .. The bar graph should sow me the values from Sep 2011 to Oct 2010.. This should vary based on the selections I do on the month-Year field .. I mean I am always intresed to see only one year data in the bar graph..&nbsp; I hope we could do the same by using 12 variables to save the 12 month values .but&nbsp; If someone could provide me any other solution with the sample QVW file that could be more helpfull..</P><P></P><P>Awaiting for the reply...</P><P></P><P></P><P>Thanks in advance...</P></BODY></HTML> Mon, 19 Sep 2011 07:51:27 GMT 2011-09-19T07:51:27Z Set Analysis expression for 1 year data in Bar graph https://community.qlik.com/t5/QlikView/Set-Analysis-expression-for-1-year-data-in-Bar-graph/m-p/270657#M583667 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I need to view 1year data based on the selction i do in the month field which has data (Jan - Dec) .. Let me explain it clearly.. I have some 4years data in my application.. If I select sep 2011 in the month-Year field .. The bar graph should sow me the values from Sep 2011 to Oct 2010.. This should vary based on the selections I do on the month-Year field .. I mean I am always intresed to see only one year data in the bar graph..&nbsp; I hope we could do the same by using 12 variables to save the 12 month values .but&nbsp; If someone could provide me any other solution with the sample QVW file that could be more helpfull..</P><P></P><P>Awaiting for the reply...</P><P></P><P></P><P>Thanks in advance...</P></BODY></HTML> Mon, 19 Sep 2011 07:51:27 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-expression-for-1-year-data-in-Bar-graph/m-p/270657#M583667 2011-09-19T07:51:27Z Re: Set Analysis expression for 1 year data in Bar graph https://community.qlik.com/t5/QlikView/Set-Analysis-expression-for-1-year-data-in-Bar-graph/m-p/270658#M583668 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>as with many other things, there are more than one possible solution. My favorite is using MonYear as a dual. This is the field MonYear has a text (for representation) and an integer value (for calculation). Take a look into my load-script, there I defined the field and a Variable called vactMonYear. With those you can easily compare and calculate like I did in the straight table chart. And it is also usable in Set Analysis.</P><P></P><P></P><P></P><P>HtH</P><P>Roland</P></BODY></HTML> Mon, 19 Sep 2011 09:30:43 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-expression-for-1-year-data-in-Bar-graph/m-p/270658#M583668 2011-09-19T09:30:43Z