topic Re: Counting values using a date in if statement in QlikView

Counting values using a date in if statement

nicalbert — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I'm trying to count the number of items from type XYZ that were created on a given day of the week. So basically, my expression should (?) have 2 "if" condition. So, let's say that I'm only counting the items of type 13 that were made on Mondays, the expression would look like:

count(if(ItemType='13',if(weekDay(ItemCreatedDate = 'Mon'), ItemId)))

Now, this obviously does not work... Can anyone provide me some help?

Thanks,

Nic

Re: Counting values using a date in if statement

kaushiknsolanki — Thu, 25 Jan 2018 19:55:41 GMT

Try this.

count(if(ItemType='13' and weekDay(ItemCreatedDate) = 'Mon', ItemId))

Regards,

Kaushik Solanki

Re: Counting values using a date in if statement

pradosh_thakur — Thu, 25 Jan 2018 19:59:07 GMT

count(if(ItemType='13' and weekDay(ItemCreatedDate) = 'Mon', ItemId))

sum(if(ItemType='13' and weekDay(ItemCreatedDate) = 'Mon', 1,0))

you may need to wrap expression in some aggr() function if using it in a text box .

Re: Counting values using a date in if statement

nicalbert — Thu, 25 Jan 2018 20:06:56 GMT

This one worked perfectly:

count(if(ItemType='13' and weekDay(ItemCreatedDate) = 'Mon', ItemId))

Thank you very much to you both, that was really fast and accurate!

Nic

Re: Counting values using a date in if statement

hjimenez25 — Thu, 25 Jan 2018 20:16:15 GMT

Hi,

Try this too, you decide which expression is better for you:

count({<ItemType={13}>} if(WeekDay(ItemCreatedDate)='Mon',ItemId,null()))

Regards.