Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
settu_periasamy
Master III
Master III

Then, You can try with TOTAL like

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

View solution in original post

6 Replies
settu_periasamy
Master III
Master III

Hi,

Did you try like this?

=Max(YourDateField)-Min(YourDateField)

Not applicable
Author

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.

settu_periasamy
Master III
Master III

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
Author

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.

settu_periasamy
Master III
Master III

Then, You can try with TOTAL like

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

Not applicable
Author

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.