topic Re: Diagram - FIXED Dimension-Values in QlikView

Diagram - FIXED Dimension-Values

Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I do have problems with a line graph and some fixed values I need actually --> the graph is looking like this right now (date selection on February 2016):

Where I am struggling with is that I want to have all month of a year listed in the dimension axis --> so January till December (Independent which month is selected). The second thing is, that I like to have all values of the previous year listed --> so in this example that the line in the datatable below of 2015 is filled out till december - also the line of the previous year should show the complete previous year.

Thank you a lot for your help!

Regards,

Barbara

Re: Diagram - FIXED Dimension-Values

sunny_talwar — Thu, 19 May 2016 13:23:15 GMT

What is the expression you are using right now? Seems like a YTD expression.

Re: Diagram - FIXED Dimension-Values

Thu, 19 May 2016 13:50:23 GMT

No - the values are monthly sums (order values).

The Dimension is Month:

The expressions are actual year values and previous year values per month:

Expression AY:

Expression PY:

we are using two variables - one for OrderValues and one for Setting the acutal year:

vOrderValues: num(sum({<$(vClearCalendar),$2>} OrderValue$(vCurrency).VBAP)/$1,'#.##0')

vAYYearSet: Date ={">=$(=date(yearstart(Date)))<=$(=Date)"}

vPYYearSet: Date ={">=$(=date(addmonths(yearstart(Date),-12)))<=$(=date(addmonths(Date,-12)))"}
vClearCalendar: ='[' & Concat({1<$Table={'CALENDAR'}>} $Field, ']=,[') & ']='

Re: Diagram - FIXED Dimension-Values

sunny_talwar — Thu, 19 May 2016 13:54:05 GMT

Try these changes

vAYYearSet: Date ={">=$(=Date(Yearstart(Max(Date))))<=$(=Date(Max(Date)))"}

vPYYearSet: Date ={">=$(=Date(AddMonths(YearStart(Max(Date)),-12)))<=$(=Date(AddMonths(Max(Date),-12)))"}

Re: Diagram - FIXED Dimension-Values

Fri, 20 May 2016 06:00:55 GMT

I tried it with your changes - but nothing changed...

how is it possible to make Settings at the Dimension axis skala??