Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bobbydave
Contributor III

Bringing trigger into expression

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) 

3 Replies
Or
Valued Contributor II

Re: Bringing trigger into expression

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.

bobbydave
Contributor III

Re: Bringing trigger into expression

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

Or
Valued Contributor II

Re: Bringing trigger into expression

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.