Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

max_qlik
New Contributor

Show value from last month day

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!

Capture.JPG



2 Replies
MVP
MVP

Re: Show value from last month day

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)

Re: Show value from last month day

maybe helpful:

Open cases as of date?

regards

Marco

Community Browser