Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with YTD value

Hello everyone,

I face the following problem in my report.

Current Year (2016) is the Financial Year (2015-2016)

  I need to do Current Year vs Last Year YTD Comparison. I am getting
correct numbers in LY YTD column, but when I click on the Year field, number
disappears and I get only hyphen.

Request anyone to help me out.

Thanks,

vidhya

12 Replies
ankitaag
Partner - Creator III
Partner - Creator III

Hi Vidhya,

Can you post a sample application. That would be much helpful.

Thanks and Regards,

Ankita

Anonymous
Not applicable
Author

try this:

sum({<Date=,Date={">=$(=vLYMinDate)<=$(=vLYMaxDate)"}>}Exit_Count)

/

(sum({<Date=,Date={"=$(=vLYMinDate)"}>}OpeningBalance)+ sum({<Date=,Date={"=$(=vLYMaxDate)"}>}ClosingBalance))/2

Not applicable
Author


Nope. it doesn't work