If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Got a problem. I'm counting days between two dates, I need to count how many network days are between the lowest date and the second to the lowest, grouped by ID.
My measure expression looks like this:
avg(networkdays(aggr(min([Send date]),[ID]),aggr(min([Send date],2),[ID])))
Now, somehow it skips the second date, which is equal to the 1st one '2020.06.11', and brings the result 21, which is between '2020.07.09' and '2020.06.11'
The outcome should look like this:
Thanks for the help!
Never knew you can accept several answers as solution 🙂