Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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
Highlighted
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
Highlighted
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

New Contributor

Re: Set Analysis and Set Expression - actual month

Works as joy - many thanks