topic Re: fetching previous month data issuse in QlikView

fetching previous month data issuse

Wed, 18 Jun 2014 08:17:51 GMT

Hi,

i have month n year filed the month field has apr may jun jul aug....mar

and year 2013 2014 2015

if i click year 2015 usually i get apr may jun but i need 2014 mar data to be displayed in the same way for 2014 apr....

note: i need it only for april month for all the years in my calendar, irrespective of my month selection

Re: fetching previous month data issuse

datanibbler — Wed, 18 Jun 2014 08:21:30 GMT

Hi bhanu,

try set_analysis. Sth. like

>>> sum({1<Month = {$(=)Getfieldselections(Month)-1))}>} Sales <<<

(the parameter 1 disregards all user selections to begin with, and then you can add whatever you want, based on user_selections or not)

HTH

Best regards,

DataNibbler

Re: fetching previous month data issuse

MK_QSL — Wed, 18 Jun 2014 08:33:19 GMT

Provide your sample data file please

Re: fetching previous month data issuse

Wed, 18 Jun 2014 08:53:13 GMT

sample data in the straight table i need to get the sum(labst+umlme) if the selction for 2015 year i need to get 2014 march and 2015 year apr may june data

Re: fetching previous month data issuse

Wed, 18 Jun 2014 09:45:10 GMT

i have provided the sample application could you please check it and provide the details