topic Re: Set analysis R12 in QlikView

Set analysis R12

Tue, 19 Jan 2016 11:03:36 GMT

hi i have some issues with my R12 calculation could someone take a look and help please.

=Count({$<[Datum]={"<=$(=DATE(Today()),'YYYYMMDD') >= $(=DATE(Today()-365),'YYYYMMDD')"}>}
DISTINCT TP_ID)

sunny_talwar — Tue, 19 Jan 2016 11:05:47 GMT

Try reversing the order and no space between )>=$(

=Count({$<[Datum]={">=$(=DATE(Today()-365),'YYYYMMDD')<=$(=DATE(Today()),'YYYYMMDD')"}>} DISTINCT TP_ID)

Update: Fixing issues in the expressions pointed out by Max

=Count({$<[Datum]={">=$(=DATE(Today()-365,'YYYYMMDD')<=$(=DATE(Today(),'YYYYMMDD')"}>} DISTINCT TP_ID)

Clever_Anjos — Tue, 19 Jan 2016 11:06:22 GMT

Is your field Datum formated YYYYMMDD?

Anonymous — Tue, 19 Jan 2016 11:11:42 GMT

Try with bypassing the date field like?

=Count({<[Datum]=, [Datum]={'>=$(=DATE(Today()-365),'YYYYMMDD')<=$(=DATE(Today()),'YYYYMMDD')'}>} DISTINCT TP_ID)

=Count({<[Datum]=, [Datum]={'>=$(=DATE(Today()-365,'YYYYMMDD'))<=$(=DATE(Today(),'YYYYMMDD'))'}>} DISTINCT TP_ID)

Note: Make sure format of Datum should be 'YYYYMMDD'

PrashantSangle — Tue, 19 Jan 2016 11:19:39 GMT

Hi,

There is closing bracket error for date()

Check and modify other wise there is no issue in your expression

It is supposed to below

Date(Today(),'YYYYMMDD')

where you did

Date(Today()),'YYYYMMDD')

same for other date(Today()-365,'YYYYMMDD')

Regards

sunny_talwar — Tue, 19 Jan 2016 11:32:52 GMT

Good catch max.

PrashantSangle — Tue, 19 Jan 2016 11:35:42 GMT

Thanks..