Show value from last month day

[Anonymous]

Hi, I’m looking for a solution with qlikview. Can you help me?

I have this input data and I want a table output like this.

I need to show value of last day of each month in Input Data. Which calculated dimension can I use?

Thank You very much!

[sunny_talwar]

May be create a flag for the last day of the month

If(Date = Floor(MonthEnd(Date)), 1, 0) as MonthEndFlag

and then use this to display your value

Dimension

Date

Expression

Sum({<MonthEndFlag = {1}>}Value)

[MarcoWedel]

maybe helpful:

Open cases as of date?

regards

Marco