topic count id based on max date in QlikView

count id based on max date

QSense — Mon, 14 Mar 2016 13:26:00 GMT

Hello ,

I have an expression like this ;

COUNT(IF(A= 1 AND B= 'UPSELL', ID)) but I want to calculate this count according to max of current year month,

I would like to count max year month's value using with my above expression. My date format is 'DD.MM.YYYY'

Thanks

swuehl — Mon, 14 Mar 2016 13:48:26 GMT

If your dates are having a numeric representation, you can use QV date functions to check if they reside in today's month:

=COUNT( IF(A=1 AND B='UPSELL' AND InMonth(DATEFIELD, Today()), ID))

Today's month should be the same as max of current year month, or are you looking for something else?

QSense — Mon, 14 Mar 2016 13:59:09 GMT

Unfortunately ıt didnt work.

Actually I waould like to see max date's value for instance it is 2016 March and ı want to count max date's value so March's value should be seen

swuehl — Mon, 14 Mar 2016 14:03:15 GMT

sorry, I don't understand what you want to count.

Could you post some sample records and your expected result?

QSense — Mon, 14 Mar 2016 14:14:51 GMT

=COUNT( IF(A=1 AND B='UPSELL' AND date=(max(date(Datefield,'YYYYMM'))) , ID))

It should be like this

When I look table for each month I want to see last year month's value

QSense — Thu, 24 Mar 2016 14:00:39 GMT

{"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}

QSense — Thu, 24 Mar 2016 14:04:09 GMT

=Count({<DATE= {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"},A = {1} ,B = {'X'},C={'Y'},C={'Z'} >} D)