Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I ' m looking for help with a following problem:
I have a button which shows next 6 months. The formula behind the action is:
=Concat(distinct{$<Date={">=$(=monthstart(today(),1))"}>*$<Date={"<$(=monthstart(today(),7))"}>} Date, ';')
Then I have a formula of a Measure:
sum({<Date={">=$(=monthstart(today(),1))"}>}[Demand [hour]]])
The button does not overwerite date selection in the formula, it ignores it completely.
Cheers
Ramina
If you have a set expression in your measure that defines a new set of dates, this should have precedence over the selection.
Try
{<Date*={">=$(=monthstart(today(),1))"}>}
instead of
{<Date={">=$(=monthstart(today(),1))"}>}
Then you will get the intersection between the two. See more on https://community.qlik.com/t5/Design/Implicit-Set-Operators/ba-p/1475624
HIC
If you have a set expression in your measure that defines a new set of dates, this should have precedence over the selection.
Try
{<Date*={">=$(=monthstart(today(),1))"}>}
instead of
{<Date={">=$(=monthstart(today(),1))"}>}
Then you will get the intersection between the two. See more on https://community.qlik.com/t5/Design/Implicit-Set-Operators/ba-p/1475624
HIC
Hey Hic, thank you - it functioned! Just a question, what does this * actually do before the 'Date'?