Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Count dates in each Week Day

Hi all, 

 

I have list of items(challengs) that have start and end date, 

what i would like to do, 

is count how many challenges have start date in each week day , and how many have end date in each week day

so for example: i have challenge.enddate of 1/13/2019 which is Sunday,

and i want it to be counted only in sunday as 1 

is it possible?

2019-02-21_15-12-51.png

Labels (2)
1 Solution

Accepted Solutions
Highlighted

May be like this

If(WeekDay([Challenges.EndDate]) = [Week Day],
Count(WeekDay([Challenges.EndDate]))
)

View solution in original post

3 Replies
Highlighted

May be this?

Create field, If WeekDay field not available in the model like WeekDay(DateField) as WeekDay

Then, Expression as follows

Count({<WeekDay = {'Sun'}>} WeekDay)

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)
Highlighted

May be like this

If(WeekDay([Challenges.EndDate]) = [Week Day],
Count(WeekDay([Challenges.EndDate]))
)

View solution in original post

Highlighted
Creator
Creator

seems to work! thx!