topic Re: last 10 months data dynamically on chart in QlikView

last 10 months data dynamically on chart

Sun, 22 Dec 2013 19:17:23 GMT

Hi,

i want the last 10 months sales.dynamicaly for changing next month also it should be changes dynamically

let me know hoe proceed in set analysis.can i do with max(month) lik that or is there any option

Re: last 10 months data dynamically on chart

aveeeeeee7en — Sun, 22 Dec 2013 20:06:36 GMT

Hi Mahesh

Try Something in your Expression:

Sum({1<Please Write Your Date Field Name Here = {">=$(=MonthStart(Max(Please Write Your Date Field Name Here), -10))<=$(=MonthEnd(Max(Please Write Your Date Field Name Here)))"}>}Please Write Your Field Name Here)

Hope this Helps You.

Re: last 10 months data dynamically on chart

jagan — Mon, 23 Dec 2013 02:20:52 GMT

Hi Mahesh,

Try like this

=Sum({<YearDimensionName= , QuarterDimensionName=, MonthDimensionName=, Date={'>=$(=MonthStart(Today(), -10))<=$(=MonthEnd(Today()))'}>} Sales)

Replace YearDimensionName, QuarterDimensionName, MonthDimensionName with you Year, Quarter and Month dimension names respectively, this will ignore the selections in those columns so that you will get the last 10 month sales even you select any of this.

If you want to get the sales of last 10 months from selected Date/Other dimensions then replace Today() with Max(DateDimensionName)

Hope this helps you.

Regards,

Jagan.