Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Identifire

Hi Guys,

please help, what does the below statement mean :

if(DAY<DAY(Today()),rangesum (above((sum({$<Year = {$(=max(Year))},StrikeReturnPartial= {Strike}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"}>}
Amount)),0,31))*-1,'')

Many thanks,

Treasure Dlamini

3 Replies

Re: Set Identifire

Expression seems to be accumulating Amount for days up-until the Today()'s day for each month

Re: Set Identifire

Taken out of context, this is damn difficult to explain. The expression refers to at most 31 previous cells in a chart/table so Sunny is probably right. Also, in each separate month, it will not pass the current day number, so its a "DayToDate" accumulation, if you can call it that way.

Can you post a screenshot with the chart dimensions?

Entering an expression like this in the expression editor and adding whitespace makes it a lot more readable. Like so:

if (DAY < Day(Today()), // Only for daynumbers smaller than today's day number

    rangesum(

             above(

                   sum({$<Year={$(=max(Year))}, // max selected year, max month in that year

                          StrikeReturnPartial={Strike},

                          Month={"<=$(=Max({<Year={$(=Max(Year))}>}Month))>$(=Max({<Year={$(=Max(Year))}>}Month)-1)"}

                         >}

                       Amount),

                   0, 31) // Go back max 31 days

            ) * -1, // Invert

    '' // Display nothing for days >= today's day number

   )

AFAIK it may do weird things in January.

Peeter

Not applicable

Re: Set Identifire

Hi Peter/Sunny

Thanks guys, I see what you mean here, Peter please see below screenshots,

I now see the numbers are accumulating, but I still don't know what does the expression min,

Community Browser