Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense select specific variable in field expression

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

1 Solution

Accepted Solutions
NZFei
Partner - Specialist
Partner - Specialist

SUM({$<Date = {'>=$(=YearStart(Today()))<=$(=date(Today()))'}, Bibliotek={Them}>}[Sum pr. dag])

View solution in original post

2 Replies
NZFei
Partner - Specialist
Partner - Specialist

SUM({$<Date = {'>=$(=YearStart(Today()))<=$(=date(Today()))'}, Bibliotek={Them}>}[Sum pr. dag])

Anonymous
Not applicable
Author

Thanks for the help Fei Xu !