Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bi_analysts_2
Creator
Creator

Count if

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

1 Solution

Accepted Solutions
bi_analysts_2
Creator
Creator
Author

Hi

the right answer is:

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

thanks!

View solution in original post

3 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
jagan
MVP
MVP

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


Set Analysis for Rolling Periods


Set Analysis for certain Point in Time


Hope this helps you.


Regards,

Jagan.

bi_analysts_2
Creator
Creator
Author

Hi

the right answer is:

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

thanks!

View solution in original post