topic Max (Period) - 1 in QlikView

Max (Period) - 1

leocattqv — Wed, 03 May 2017 18:34:18 GMT

Hi all,

I have a line chart that I dont want to show the current month because the lines just fall off the cliff.

my current formula is producing No data - I cant seem to find any syntax errors but I dont know why its not working?

Ideas?

formula is

=Num(Count({<

Period = {"<=$(=Max(Period)-1)"}, Year = {"$(=Max(Year))"}>}ID),'#,##0')

Re: Max (Period) - 1

lironbaram — Wed, 03 May 2017 18:52:23 GMT

what is the format of the period field ?

Re: Max (Period) - 1

craigsutton — Wed, 03 May 2017 18:58:46 GMT

<Dimension -= another set>: remove the set from the current selection

=Num(Count({< Period -= {"$(=Max({1}Period))"}, Year = {"$(=Max(Year))"}>}ID),'#,##0')

Re: Max (Period) - 1

leocattqv — Wed, 03 May 2017 19:08:27 GMT

that worked, thanks so much

Re: Max (Period) - 1

leocattqv — Thu, 04 May 2017 19:28:11 GMT

One More Question - Say I dont want Period as before, say I wanted Week. Wouldnt it be the same calculation with a different field? Im trying to cut to only the completed week

=Num(Count({<

YearWeek -= {"$(=Max({1}YearWeek))"},Year = {"$(=Max(Year))"}>}ID)

Re: Max (Period) - 1

craigsutton — Fri, 05 May 2017 21:50:04 GMT

Is it not working? if you have a field that labels each date be week of the year then it should work.