Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Getting number of days in a Months Filter

Hello again fello Qlikers,

I wanted to get the number of days in the selected month. For example, in the above app, when I selected Oct 2015 and Sept 2015,

a measure is to be shown "61 days" How could I do it?

Thanks Qlikers.

1 Solution

Accepted Solutions

Re: Getting number of days in a Months Filter

Then, You can try with TOTAL like

=Max(Total DateField)-Min(Total DateField)

6 Replies

Re: Getting number of days in a Months Filter

Hi,

Did you try like this?

=Max(YourDateField)-Min(YourDateField)

Not applicable

Re: Getting number of days in a Months Filter

1) Month = a dimension i made.

by using the expression   "MonthName(DATE(dateSet))"

2) dateSet is a set of dates joined by 2 excel files

3) So right now, I would like to create a measure that shows 61 days if i select september and october.

Re: Getting number of days in a Months Filter

So, if you select september an October, in the dimension the two Months will display, right?

Can you attach the Screen shot with Month Dimension?  And do you want to display the 61 days every row?

Not applicable

Re: Getting number of days in a Months Filter

The first post has the screenshot.  The intention is to get say, Available Qty/number of days.

Which means, every record in the table shown in the screenshot, would have a new column Av.Qty/nDays.

Re: Getting number of days in a Months Filter

Then, You can try with TOTAL like

=Max(Total DateField)-Min(Total DateField)

Not applicable

Re: Getting number of days in a Months Filter

your reply lead me to this

Ceil(MonthEnd(Max(Date(dateSet))) - MonthStart(Min(Date(dateSet)))) . And I get what I wanted.

Thanks Settu. Been headaching about this.