Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
andreyfcdk91
Contributor

Dates between monthend and last weekend

Colleagues, good day!

I'm working now with fetching dates between every monthedns and the last weekend of the month.

What i need?

i have one calculated dimension:

=If(WeekEnd([Date])>=MonthEnd([Date]), MonthEnd([Date]),WeekEnd([Date]))

which set monthend only if dates are between monthend and last weekend.

Task - to set here 1.

6.jpg

I've already tried such expr as:

if(Date>=

max(total <month(Date)&year(Date)> weekend(Date))

and Date<=monthend(Date)

)

But it doesn't work.

Have anyone idea how to fetch this?

Thanks. ! !

5 Replies

Re: Dates between monthend and last weekend

May be I have one free idea for you, because within TOTAL keyword calculators won't work

Create one field in script

Month(Date)&year(Date) as monthyear

And expression is similar to this, and remind you date format should be same when we ate working for equal sign

if(Date>=

max(TOTAL <monthyear> weekend(Date))

and Date<=monthend(Date), firstargument,secondargument

)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
andreyfcdk91
Contributor

Re: Dates between monthend and last weekend

Thanks, dear!

I checked it, but it shows the same date for all dates (takes the max of the year)

7.jpg

Re: Dates between monthend and last weekend

If you use only max(TOTAL ...) always give maximum date only. And, in your expression heading it shows the same and you May need to use the if..else.. where I gave

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
andreyfcdk91
Contributor

Re: Dates between monthend and last weekend

yes, but in this case i always with compare dates with max weekend date of the calendar.

Re: Dates between monthend and last weekend

The reason I am replying, I am not opening your application due to software is not installed in my machine.

If(date = max(total calendardate),1,0) ..

If you need this, you can comparing using compound flags into the variable component

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)