topic Re: If statement in QlikView

If statement

Thu, 04 Jul 2013 13:15:09 GMT

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,

Re: If statement

Gysbert_Wassenaar — Thu, 04 Jul 2013 13:20:58 GMT

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)

Re: If statement

Thu, 04 Jul 2013 13:22:52 GMT

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

Re: If statement

Thu, 04 Jul 2013 13:26:22 GMT

Thank you very much