Discussion Board for collaboration on Qlik NPrinting.
I have a field name _MonthNum (he gave me the number between 1 and 12) and i would like to create a filter on this field.
And i would like to obtain all the monthNum < max(_MonthNum).
I try a lot but i can't find a solution yet.
I think this also answers your question..
Advanced Search filters in NPrinting 17.5
There is a work around for this. Create a new table containing all possible values. Filter on that in NPrinting. And with this value you can do a set analysis <= like u usually do.
Hope I was clear enough, if not I can create an example.
Could you create en example of this?
create this as column in Qlik
and use that field as filter for report or task.
This is how I have it:
I added this to the kalendar:
Num(Year(TempDate) & ',' & num(Month(TempDate))) AS Kalender.MaandJaarNummer, // results in: <year>,<Month>
Added this table to use in the NPrinting filter:
distinct Kalender.MaandJaarNummer AS Rapport_MaandJaarNummer
You can then for example use 2017,12 as a cumulative filter for 2017 all months (keep in mind , is decimal here in the netherlands not the .)
In your set analysis you use this to calculate the month (same for year with subfield 1:
=if(max([Rapport_MaandJaarNummer]) < num(Year(Today()) & ',' & num(Month(Today()))),subfield([Rapport_MaandJaarNummer],',',2),num(month(addmonths(Today(),-1))))
And this in the set analysis you are using on the calculation:
(Translations: maand=month jaar=Year)