Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Then, You can try with TOTAL like
=Max(Total DateField)-Min(Total DateField)
Hi,
Did you try like this?
=Max(YourDateField)-Min(YourDateField)
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.
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?
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.
Then, You can try with TOTAL like
=Max(Total DateField)-Min(Total DateField)
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.