Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mark_andersen
New 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

Tags (2)
1 Solution

Accepted Solutions
xufei123
Valued Contributor

Re: Qlik Sense select specific variable in field expression

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

2 Replies
xufei123
Valued Contributor

Re: Qlik Sense select specific variable in field expression

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

mark_andersen
New Contributor

Re: Qlik Sense select specific variable in field expression

Thanks for the help Fei Xu !