Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
soniasweety
Valued Contributor III

last day

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.

Tags (1)
1 Solution

Accepted Solutions

Re: last day

May be this

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

View solution in original post

7 Replies

Re: last day

May be this as your expression

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

Partner
Partner

Re: last day

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

I can walk on water when it freezes
soniasweety
Valued Contributor III

Re: last day

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
Valued Contributor III

Re: last day

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

Re: last day

May be this

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

View solution in original post

soniasweety
Valued Contributor III

Re: last day

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

Re: last day

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