Qlik Community

Qlik Sense App Development

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

Highlighted
gal_polak
New Contributor III

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

Tags (2)
Labels (2)
1 Solution

Accepted Solutions

Re: Count dates in each Week Day

May be like this

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

Re: Count dates in each Week Day

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)

Re: Count dates in each Week Day

May be like this

If(WeekDay([Challenges.EndDate]) = [Week Day],
Count(WeekDay([Challenges.EndDate]))
)
gal_polak
New Contributor III

Re: Count dates in each Week Day

seems to work! thx!