Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 !