Set Expression - Exclude all calendar fields but allow all others fields

[mikkelba]

Hello,

What is the syntax to exclude all fields of a specific kind (e.g. calendar fields) from a set expression but allow other selections in all other fields (e.g. product type or some ID)?

An example of a measure that sums the last 10 days of "A" in Table.Field:

Sum({$< [Table.Date.Calendar.YearMonth], [Table.Date.Calendar.Date] = {"$(= '>' & Date(vToday-11))"}, [Table.Field] = {'A'}>} [Table.Count])

My problem is that I have several calendar functions with the syntax [Table.Date.Calendar.XXX] such as Year, Month, YearMonth, YearQuarter, Quarter, YearWeek etc. In the above example I am only ignoring the YearMonth function and I could do the same with all the calendar fields, but I am hoping for a better solution as I have quite many calendar functions. Is there any way to exclude all selection with the prefix [Table.Date.Calendar.*] but allow all others?

The calendar function is called through a sub-routine so the calendar I am using is not the standard from Qlik.

Thanks in advance!

[Frank_Hartmann]

have a look here:

https://community.qlik.com/t5/New-to-QlikView/Set-Analysis/td-p/110569

https://community.qlik.com/t5/QlikView-Documents/Ignore-all-selections-except-few-fields-using-Set-A...

hope this helps