topic Re: Count if in QlikView

Count if

Anonymous — Sun, 15 May 2016 14:00:35 GMT

Hi,

How can i use the count aggregation function of a date field (dd/mm/yyyy) when the field value is from the last 6 months/half a year?

meaning: count this field when its value is from the last 6 months.

for instance, the date field name is [initial insert date].

Thanks!

Tal

Gysbert_Wassenaar — Sun, 15 May 2016 17:11:39 GMT

Perhaps like this: count({<[initial insert date]={"=[initial insert date]>$(=AddMonths(Max([initial insert date]),-6))"}>} [initial insert date])

jagan — Sun, 15 May 2016 17:51:25 GMT

Hi,

Try like this

=Count({<[initial insert date] = {'>=$(=AddMonths(Today(), -6))<=$(=Today())'} [initial insert date])

You can find similar type of expressions from the link below

Hope this helps you.

Regards,

Jagan.

Anonymous — Mon, 23 May 2016 08:14:20 GMT

the right answer is:

Count({<[initial insert date]={">=$(=Date(AddMonths(Today(),-6),'MM/DD/YYYY'))"}>} [initial insert date])

thanks!