Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik community
I have an expression SUM({$<Date = {'>=$(=YearStart(Today()))<=$(=MonthsStart(Today()))'}>}[Sum pr. dag])
Sum pr. dag = sum of visitors
It slows me the total visitors from 2018 to today
I have made a field "Bibliotek" to differentiate visitors on four libraries.
I would like visitors to a specific library ("Them") along with the formula for date
I hope someone can help me.
Best regards Mark
SUM({$<Date = {'>=$(=YearStart(Today()))<=$(=date(Today()))'}, Bibliotek={Them}>}[Sum pr. dag])
SUM({$<Date = {'>=$(=YearStart(Today()))<=$(=date(Today()))'}, Bibliotek={Them}>}[Sum pr. dag])
Thanks for the help Fei Xu !