Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis based on each value of the time dimension

I have a time dimension, basically dimension is end date of each month. I have a calulation based on end of each month, basically my calculation should be based on end of each month, which is diplayed in x axis of the chart.

say chart

Month Last Date

My calculation COUNT(if A/c Open date >= Month Last Date and A/c Open date<=Month Last Date, ACT ID)

Month last date should be based on each value in the x- axis

Thank you

1 Reply
israrkhan
Specialist II
Specialist II


try liek this..


Count({<[A/c Open date]= '{>=$(MonthEnd(YourDate))}', [A/c Open date] = '{<=$(MonthEnd(YourDate))}'>} [ACT ID] )