topic Trends in line chart based on selection in QlikView

Trends in line chart based on selection

Fri, 30 May 2014 10:53:40 GMT

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

Re: Trends in line chart based on selection

Anonymous — Fri, 30 May 2014 17:13:48 GMT

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