Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
New Contributor

Set Analysis and Set Expression - actual month

I've created a dashboard with daily-values. I used a trigger, when the .qvw opens select Date as follows 

 

firstworkdate(today(),3, $(vFeiertage))

 

I also want to show cumulated values, in this example the sales. If the formula above returns a date like 12.02.2020 i need to get 01.02.2020 till 12.02.2020 in my set expressions/analysis. 

 

But how to?

1 Solution

Accepted Solutions
MVP
MVP

Re: Set Analysis and Set Expression - actual month

You can try using MonthStart() like:

">=MonthStart(firstworkdate(today(),3, $(vFeiertage)))   <=firstworkdate(today(),3, $(vFeiertage)) "

View solution in original post

2 Replies
MVP
MVP

Re: Set Analysis and Set Expression - actual month

You can try using MonthStart() like:

">=MonthStart(firstworkdate(today(),3, $(vFeiertage)))   <=firstworkdate(today(),3, $(vFeiertage)) "

View solution in original post

Highlighted
New Contributor

Re: Set Analysis and Set Expression - actual month

Works as joy - many thanks