Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

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

Tags (3)
1 Solution

Accepted Solutions

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

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

2 Replies

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

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

Not applicable

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

Thank Kaushik.

You are a Star!

Community Browser