topic Re: Dimension in set analysis in QlikView

Dimension in set analysis

Mon, 03 Dec 2012 08:25:58 GMT

Hello!

I habe a dimension YYYYMM which will be the ascending year and month and i want to count the Field No_ for each dimension where the fields beginYYYYMM <= YYYYMM and endYYYYMM >=YYYYMM

I tried some code samples of the community but i failed

Please help

regards

Georg

Re: Dimension in set analysis

Mon, 03 Dec 2012 08:50:13 GMT

Count({<YYYYMM={">=$(beginYYYYMM)<=$(endYYYYMM)"}>}Rowno)

Re: Dimension in set analysis

Mon, 03 Dec 2012 09:14:52 GMT

I´am getting the same Value for each row.

I tried

Count({<YYYYMM={">=$(beginYYYYMM)<=$(endYYYYMM)"}>}[Account No_])

Re: Dimension in set analysis

jagan — Fri, 21 Dec 2012 07:51:52 GMT

Hi,

I think your expression won't work because the compare is done based on the string not date. If you have corresponding dates for all the YYYYMM fields then you can do this by using this fields

=Count({<YYYYMMDateField={">=$(=beginYYYYMMDateField)<=$(=endYYYYMMDateField)"}>}[Account No_])

Hope this helps you.

Regards,

Jagan.