topic Re: last day in QlikView

last day

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i want to display the chart only monthend values only

currently am getting total month numbers

used dimension: =aggr(if([Month Year Num]>'$(vSelectedMonth)',[Month Year]),[Month Year])

Exp: Count(Number) so it is giving me last 10 months data in bar chart

so now I want only each monthend date how many numbers are there that only need to show?

how to use monthend in my measure.

sunny_talwar — Tue, 24 Apr 2018 12:05:43 GMT

May be this as your expression

Count(If(Date = Floor(MonthEnd(Date)), Number))

ali_hijazi — Tue, 24 Apr 2018 12:07:39 GMT

your dates in the fact table include the day or only month and year?

soniasweety — Tue, 24 Apr 2018 13:02:03 GMT

thanks sunny its working but

there is one logic in between

I want to get till last month it needs to show and but current month should show max date count ?

soniasweety — Tue, 24 Apr 2018 13:03:03 GMT

how to show only max month should show max date numbers and all previuos months should show monthend date count

sunny_talwar — Tue, 24 Apr 2018 13:05:24 GMT

May be this

Count(If(Date = Floor(MonthEnd(Date)) or Max(TOTAL Date), Number))

soniasweety — Tue, 24 Apr 2018 13:54:35 GMT

thanks sunny its working can you explain how max(total Date) will work?

sunny_talwar — Tue, 24 Apr 2018 13:56:23 GMT

Max(TOTAL Date) will be evaluated as True for the Max Date and false for every other Date....