Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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