Trends in line chart based on selection

[#1]

Hi All,

There is a requirement where as in user selects the month(may), due to qlikview functionality the data get redueced to may based on selections but the user would like to see the trend from jan to May.

If the selection is august then instead of just showing Aug we need to show jan to august..

any ssuggestions appreciated.

Thank you..

[Anonymous]

Hello,

To calculate year-to-date numbers, try using set analysis in your expression.

Example:

=Sum({$<[Calendar Date] = {'>=$(=(Date(vDateMin)))<=$(=Date(vDateMax))'} >} [Line Amount])

Variable Overview:

vDateMin =YearStart(Min([Calendar Date]))

vDateMax =MonthEnd(Max([Calendar Date]))

Cheers!

Sean