topic Year to date based on Current Month/week/day Selection in QlikView

Year to date based on Current Month/week/day Selection

Tue, 30 Apr 2013 13:50:08 GMT

Hi All,

Im trying to find a method of showing Year To date against other figures.

My users will be selecting a a minumum of the Year but may also select other criteria , such as Day, Month , Week, Quarter.

I need to show a sum for the selection but i want to show a Year to date figure based solely on the Year Selection and disregard the other slections

I have tried tweaking this standard expression (below)but i appear to be missing something

sum( {$<Year = {$(#=Only(Year))}>} CURSALES )

Thank you

Michael

Re: Year to date based on Current Month/week/day Selection

kaushiknsolanki — Tue, 30 Apr 2013 17:31:52 GMT

Hi,

If you want user to see only year to date result even if they select the date and month and week then you must exclude those selection as shown in below expression.

sum( {$<Year = {$(#=Only(Year))},Month=,Week=,Day=,Date=>} CURSALES )

Regards,

Kaushik Solanki

Re: Year to date based on Current Month/week/day Selection

Wed, 01 May 2013 12:59:29 GMT

Thank Kaushik.

You are a Star!