Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

hkhkhkhk
New Contributor

YTD based on Selection for Financial Year

Hi All,

I have a query that I cannot seem to resolve.

I have a field called 'MonthYear' which has the following format 'MMM-YYYY'.

I wanted to calculate the sum year-to-financial-date of revenue based on the selection in the list box.

My financial year starts in July. Please note i would like to do this without the use of variables.

For example if the user selects Feb-2015 from the MonthYear listbox, the calculation should sum revenue from July-2014 to Feb-2015.

Thanks for you help in advance.

Tags (1)
2 Replies

Re: YTD based on Selection for Financial Year

Can you post a small qlikview document that demonstrates the problem?


talk is cheap, supply exceeds demand
Digvijay_Singh
Honored Contributor III

Re: YTD based on Selection for Financial Year

try something like Sum(if(yeartodate(date,0,7),Revenue))

Community Browser