Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

If statement

Hi,

can you help - I want to count the number of sessions that are classed as waiting list initiatives, but split them for week and weekend. I have a day if week variable and the session type variable is where you will find waiting list initiative amongst others. At the moment it is just counting all of the session types.

So I need - if the day of the week is sat or sun and the session type is waitinglist initiatives then count how many there are...

=if(day_of_week, 'Saturday' or 'Sunday' and session_type = 'Waiting List Initiative',

count (session_type))

Thanks,

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

If you have fields named day_of_week and session_type you can try this:

count({<day_of_week={'Saturday','Sunday'},session_type={'Wailting List Initiative'}>} session_type)


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

If you have fields named day_of_week and session_type you can try this:

count({<day_of_week={'Saturday','Sunday'},session_type={'Wailting List Initiative'}>} session_type)


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

count({<day_of_week={'Saturday','Sunday'},session_type={'Wailting List Initiative'}>} session_type)

Highlighted
Not applicable

Thank you very much