Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Data Island Date as Dimension

Hello,

I'm trying to create bar chart with data island date as dimension. I'm facing a challenge in getting the required output. My measure is as follows:

Dimensions: Year-Quarter-Month-Day(From DataIsland)

Measure: count({<BTL_TRANS_TYPE-={2},B_ISCANCELED={0},ISCANCELED={0},BTL_TRANS_DATE={">=$(vMaxDate365) <=$(vMaxDate)"}>}distinct BENEFICIARY_KEY)

vMaxDate:  =Date(max(Date))

vMaxDate365: =Date(max(Date)-365)

The bold variables are from data island. I'm getting the same result for all the years.

I need the count of beneficiaries who has transactions between 365 days from the max date for each date.

The above measure gives correct values as a kpi object with selections too.

For example:

Jan 01, 2017 - the count should be from the measure which is count of beneficiaries for the past year (Dec 01, 2016 - Jan 01, 2017)

Feb 01, 2017 - the count should be from the measure which is count of beneficiaries for the past year (Jan 01, 2017 - Feb 01, 2017)

etc...

0 Replies