topic Re: Line Chart Current Year Vs Last Year in App Development

Line Chart Current Year Vs Last Year

rathnam_qv — Wed, 01 Nov 2017 03:58:49 GMT

Hi All,

PFA image.

I have a line chart showing current year trend and previous trend.

But the issue is with current year trend. For current year i am taking JAN to OCT but the line is connecting to NOV and DEC with the value 0.

i don't want to connect it to Nov and Dec. i have selected the option "Show as gaps" also still it is not working as expected.

My Expression for Current Year -- sum({<Year={'$(Max(Year))'}>}values)

Can anyone suggest me how to resolve it.

Thanks in advance.

Rathnam.

Re: Line Chart Current Year Vs Last Year

Anonymous — Wed, 01 Nov 2017 04:59:08 GMT

hello muniratham ,

for current year u can this expression

Sum({<OrderDate={">=$(=(YearStart(Max(OrderDate))))<=$(=Max(OrderDate))"},Year=,Month=>} [values])

and for previous year u can use this expression,

Sum({<OrderDate={">=$(=(YearStart(Max(OrderDate),-1)))<=$(=YearEnd(Max(OrderDate),-1))"},Year=,Month=>} [values])

hope it will work,

regards

Rohit lohani

Re: Line Chart Current Year Vs Last Year

Anonymous — Wed, 01 Nov 2017 05:00:19 GMT

Hi,

In my app if current year Oct Nov values are zero then its not shows Trend on those Month

I have attached QVW , pls check

Regards

Re: Line Chart Current Year Vs Last Year

Anonymous — Wed, 01 Nov 2017 05:52:11 GMT

if(sum({<Year={'$(Max(Year))'}>}values)=0,null(),sum({<Year={'$(Max(Year))'}>}values)) write this expression and in add on tab uncheck include zero value

Re: Line Chart Current Year Vs Last Year

rathnam_qv — Wed, 01 Nov 2017 06:01:04 GMT

Hi Kulwant,

Thank You very much. It's works for me.

Thanks,

Rathnam.

Re: Line Chart Current Year Vs Last Year

mdmukramali — Wed, 01 Nov 2017 06:19:49 GMT

Hi,

Attached Sample working apps,

maybe helpful to some others,

Thanks,

Mukram

Re: Line Chart Current Year Vs Last Year

Anonymous — Tue, 12 Jun 2018 14:27:51 GMT

Hi, I see the post is a bit old, but may I ask you how did you manage to put in the line graph both current and previous year lines? I am having troubles with finding the right formula to do this, it either shows me the current year and previous all zero or both is given the same value.

Here is what I'm using as formulas:

C.Y: sum({$ < YearMonth={"<=$((Month(Today())))"}, Year={"<=$((Year(Today())))"} >}[Orders])

L.Y : sum({$ < YearMonth={"<=$(( YearMonthPrevious))"} >}[Orders])

Thanks in advance!