topic Re: Bringing trigger into expression in QlikView

Bringing trigger into expression

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

So I am using nPrinting 17.5 and I've noticed that there is a bug that it doesn't like triggers when picking up the qvw.

My app has a trigger that OnActivateSheet(),

Field: Fiscal_Year_Month_Num

Search String: = '>='& vFiscalYearMonth1Year

where vFiscalYearMonth1Year =num(addmonths(MonthStart(today()),-15))

I am instead trying to bring this into my expression so that I can apply it to all my graphs rather than depend on the Trigger

Including the >= symbols is screwing up my set analysis.

Any ideas?

sum({<OffSystem.CountryCode-={'UK'},OffSystem.Measure={'New Claims added to Off-Systems MTD'},OffSystem.CoverType-={'Total'}>}OffSystem.MeasureValue)
+ sum({<%Calendar={'>= 41273'}, OffSystem_Reg.CountryCode-={'UK'}, OffSystem_Reg.Measure={'New Claims Added to Off-Systems MTD'}, OffSystem_Reg.CoverType-={'Total'}>}OffSystem_Reg.Value)

Re: Bringing trigger into expression

Or — Thu, 16 Aug 2018 14:13:20 GMT

Directly from the Set Modifiers help page:

sum( {$<Year = {“>1978<2004”}>} Sales )

Returns the sales for the current selections, but with a numeric search used to scope the range of years to sum the sales across.

Hopefully that'll fix your >= problem.

Re: Bringing trigger into expression

bobbydave — Thu, 16 Aug 2018 14:18:43 GMT

The variable changes. I am trying to create a graph that shows the last 15 months.

This month will show May 2017-July2018, next month variable will change to June 2017-Aug 2018 and so on so hardcoding wont work

Re: Bringing trigger into expression

Or — Thu, 16 Aug 2018 14:22:45 GMT

I think the focus here is on using double quotes rather than single quotes, but if that's still not going to solve your problem, you could try sticking the quotes directly into the variable - I think set analysis would parse it correctly if the contents of the variable were ">Formula()". Not 100% sure though.