Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Trends in line chart based on selection

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..

1 Reply
Highlighted
Creator
Creator

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