topic Re: Chart line stop at current month in QlikView

Chart line stop at current month

Anonymous — Wed, 13 Jun 2018 11:40:28 GMT

I am struggling with this problem for days now, hopefully somebody can help me with this problem. I have a chart with 3 lines to compare the sales with the sales a year before. When I compare the sales off this year with the sales last year I want to stop the line at current month. Does somebody know how I can do this?

The expression I use:

2017 vs 2018 sum({1< Year = {2018} >}Sales) - sum({1< Year = {2017} >}Sales)

2016 vs 2017 sum({1< Year = {2017} >}Sales) - sum({1< Year = {2016} >}Sales)

2015 vs 2016 sum({1< Year = {2016} >}Sales) - sum({1< Year = {2015} >}Sales)

Re: Chart line stop at current month

tomer1984 — Wed, 13 Jun 2018 11:56:08 GMT

HI Rakis

I think you can use Year to Date function to create a field

to compare the time pass from the start of the year till the current day

The user will have to select YTD and the 2 years

Example in the script :

If(inyeartodate( Date, today(), year(Date)-year(Today())),'YTD',NULL()) AS YearToDate,

Hope it helps

Tomer Biran

Re: Chart line stop at current month

sunny_talwar — Wed, 13 Jun 2018 12:04:13 GMT

Check the attached

Re: Chart line stop at current month

StevePaulich — Thu, 28 Feb 2019 17:19:02 GMT

IN THE EXPRESSION:

=IF([PERIOD_CHECK] < [MAX_PERIOD_CHECK], SUM(X))

**************************************************************************
WHERE PERIOD_CHECK = YYYYMM (TRANSACTIONAL DATE)
MAX_PERIOD_CHECK = YYYYMM (DATE TO STOP DISPLAYING LINE)