Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)