Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

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
Partner
Partner

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

View solution in original post

2 Replies
Partner
Partner

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

View solution in original post

Contributor
Contributor

Thanks for the help Fei Xu !