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

mikkelba — Sat, 16 Nov 2024 20:32:53 GMT

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!

topic Set Expression - Exclude all calendar fields but allow all others fields in QlikView

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

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