Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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
Gysbert_Wassenaar

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
Not applicable
Author

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

Not applicable
Author

Thank you very much