Hello,
I currently use a replace function in Qlik Sense to allow users to select KPIs from a List Box from dynamic expressions in my load script. EventType is common in all of my formulas so I use a replace function to add in different time flags.
$(=replace(only({1<FormulaOrder={"$(=min(FormulaOrder))"}>} Formula), 'EventType', 'CurrentYearToDate = {1}, EventType'))
I've recently added the date range picker extension and want to leverage the user selection range for current and prior year calculations.
I was thinking I may be able to leverage the GetFieldSelections and a replace function to get what I need. On top of that I would need to add it into the existing replace function I already use.
I was thinking I could combine the above with this type of replacement but I'm not even close to getting it to work.
replace((GetFieldSelections(CalendarDate)),'Year(Today())','Year(Today())-1')
End goal would look something like this
$(=replace(only({1<FormulaOrder={"$(=min(FormulaOrder))"}>} Formula), 'EventType', 'CalendarDate =replace((GetFieldSelections(CalendarDate)),[Year(Today())],'Year[Today())-1]), EventType'))
Any ideas?
Thanks!
