topic Re: YTD for the below expression.. in App Development

YTD for the below expression..

kavita25 — Fri, 09 Dec 2016 10:00:23 GMT

Hi,

Please help me with the logic for YTD..

My expression is :

sum(If(Val_Date >= Cal_MonthYear and Val_Date < AddMonths(Cal_MonthYear, 1), [Net Tractor Revenue (Domestic)]))

sum(If(Link_Date >= Cal_MonthYear and Link_Date < AddMonths(Cal_MonthYear, 1), [Net Tractor Revenue (Domestic)])))

I want to show YTD with the above expression..

For e.g If i select Sep Month then it should show from Apr to Sep..

stalwar1‌gwassenaar‌

Regards,

Kavita

Re: YTD for the below expression..

shraddha_g — Fri, 09 Dec 2016 10:04:40 GMT

Try

sum({<Val_Date = {">=$(=date(yearstart(max(Val_Date),0,4)))<=$(=date(max(Val_Date)))"},Cal_MonthYear=>} [Net Tractor Revenue (Domestic)])

Re: YTD for the below expression..

sunny_talwar — Fri, 09 Dec 2016 10:07:12 GMT

How about this?

Sum({<Val_Date = {"=Only({<Cal_MonthYear>} Val_Date) >= Only({<Cal_MonthYear>} Cal_MonthYear) and Only({<Cal_MonthYear>} Val_Date) < AddMonths(Only({<Cal_MonthYear>} Cal_MonthYear), 1)"}>} [Net Tractor Revenue (Domestic)])

Sum({<Link_Date = {"=Only({<Cal_MonthYear>} Link_Date) >= Only({<Cal_MonthYear>} Cal_MonthYear) and Only({<Cal_MonthYear>} Link_Date) < AddMonths(Only({<Cal_MonthYear>} Cal_MonthYear), 1)"}>} [Net Tractor Revenue (Domestic)])

Re: YTD for the below expression..

kavita25 — Fri, 09 Dec 2016 10:09:23 GMT

Its not working...

I want to show this in line chart Monthly trend...where on selection of any month..

It should show from Apr to selection Month..

Dimension Is Month and Expression as mentioned before.

Re: YTD for the below expression..

sunny_talwar — Fri, 09 Dec 2016 10:11:24 GMT

Can you check both the expressions individually to see if one of them works? If one works, we can just focus on the other

Re: YTD for the below expression..

Gysbert_Wassenaar — Fri, 09 Dec 2016 10:12:23 GMT

Please post a small Qlik Sense app with example data that demonstrates the problem.

Re: YTD for the below expression..

kavita25 — Fri, 09 Dec 2016 10:21:05 GMT

Yes..I checked..its not working..

Cal_MonthYear is Calendar Field..

and ValDate, Link Date are the tables field..

I am not linking the Calendar with these dates..and my Year & Month filters are Calendar fields filters...

So I want to show YTD on the basis of Calendar(Year & Month filters).

Re: YTD for the below expression..

sunny_talwar — Fri, 09 Dec 2016 10:24:02 GMT

I think it would be easier to understand what you are trying to do, if you can share a small sample

Re: YTD for the below expression..

kavita25 — Fri, 09 Dec 2016 10:27:34 GMT

PFA

Re: YTD for the below expression..

sunny_talwar — Fri, 09 Dec 2016 10:29:53 GMT

Which sheet are we looking into?

Re: YTD for the below expression..

kavita25 — Mon, 12 Dec 2016 05:41:00 GMT

2nd sheet.

Please help me with this issue..

Re: YTD for the below expression..

kavita25 — Mon, 12 Dec 2016 10:53:10 GMT

stalwar1‌gwassenaar‌

Have u checked the app...

Please help me with this issue..

Re: YTD for the below expression..

kavita25 — Tue, 13 Dec 2016 09:24:00 GMT

gwassenaar‌

I have attached an app..Kinldy look into the app..

& Please help me to resolve it..

Re: YTD for the below expression..

Gysbert_Wassenaar — Tue, 13 Dec 2016 09:34:19 GMT

Fix your data model first. The calendar is a data island and not linked with your other table. There are also only two Val_Date values in that table.

Re: YTD for the below expression..

kavita25 — Tue, 13 Dec 2016 10:18:45 GMT

Yess...There are only two date values coz its dummy data..

And my calendar is not linked with master calendar...

Re: YTD for the below expression..

kavita25 — Mon, 19 Dec 2016 09:36:52 GMT

stalwar1‌

I have attached the qvf..

Please look into this..