Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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