topic Re: retrieve on a certain date? in QlikView

retrieve on a certain date?

n1ef5ng1 — Thu, 08 May 2014 00:48:46 GMT

Hi I have a table that has the dimension Month_Year and Expression with a formula.

The formula is an expression that (a+b) / c

a and c data is updated daily on our system and b is updated every monday.

Is there any codes that I can do to ensure that the current month (not the historical months) will only compute based on every monday?

saying that today is wednesday, the figure is still on latest monday instead of today as it will dilute the % away.

Thu, 08 May 2014 01:49:07 GMT

May be like this.

jagan — Thu, 08 May 2014 01:54:51 GMT

Hi,

Try like this

=Sum({<DateDimensionName= {'<=$(=WeekStart(Max(DateDimensionName)))'}> } a)

The above expression will give you the sum of a until Monday of current week.

Regards,

Jagan.