Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

n1ef5ng1
Contributor

retrieve on a certain date?

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.

2 Replies
Not applicable

Re: retrieve on a certain date?

May be like this.

MVP
MVP

Re: retrieve on a certain date?

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.

Community Browser