Discussion board where members can get started with QlikView.
I've created a dashboard with daily-values. I used a trigger, when the .qvw opens select Date as follows
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?
You can try using MonthStart() like:
">=MonthStart(firstworkdate(today(),3, $(vFeiertage))) <=firstworkdate(today(),3, $(vFeiertage)) "
View solution in original post
Works as joy - many thanks