topic Month as dimension in QlikView

Month as dimension

Anonymous — Sun, 13 Sep 2015 18:37:10 GMT

Hello Community

This question might be simple but I need some solution

I appreciate your time

In attached example I need Year and month as x-axis and sum(Val) is expression as Y-axis

Thanks

Re: Month as dimension

sunny_talwar — Sun, 13 Sep 2015 18:47:38 GMT

May be use

MonthName(Date)

MonthName(MakeDate(Year, Month, 1))

as your dimension and

sum(Val)

as Expression

Re: Month as dimension

kolov007 — Sun, 13 Sep 2015 19:13:55 GMT

Hello.

You can use:

Year(Date)&'-'&Month(Date) as YearMonth

Field YearMonth you can use in chart. On tab "Sort" in the chart properties tick near State - Ascending.

Re: Month as dimension

Anonymous — Sun, 13 Sep 2015 20:21:19 GMT

See if the attached helps

Re: Month as dimension

maxgro — Sun, 13 Sep 2015 21:28:15 GMT

See attachment

Re: Month as dimension

MarcoWedel — Sun, 13 Sep 2015 22:23:37 GMT

Hi,

one solution could be also:

hope this helps

regards

Marco

Re: Month as dimension

Anonymous — Mon, 14 Sep 2015 12:41:28 GMT

Hi Sunny

I appreciate your reply. Still I am getting one dimension only

Thanks

Re: Month as dimension

Anonymous — Mon, 14 Sep 2015 13:50:43 GMT

Hi Marco Thanks for your reply, In case of month 6 is not available than I think we need use mod/avg function right? I appreciate your very helpful answer