Set analysis

[Akash]

Hi Qlikexperts,

I'm stuck with the below expression:

=max( {$<Day_number_year={"=max(Confirmed) > 1000"} * {"=max(Confirmed) < 1100"}>} Day_number_year)

using the following dimensions: Confirmed, Day_number_year

I need to find how many days it took for each state to reach the First 100,500.1000,3000 cases and represent them in Bar graph, The above expression only works in Kpi for few States and I couldn't use it in the bar graph. Is there any better approach for this Problem?

DayNumberOfYear(Date,2) as Day_number_year

The confirmed dimension is a Cummalitve YTD confirmed cases

How can I achieve it?

Please help me.

Best Regards

Akash M