Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
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