topic Re: calendar as data island in QlikView

calendar as data island

m_woolf — Thu, 03 Sep 2015 19:06:19 GMT

I have a master calendar that is not linked to nay other table.

In my expression, I use something like: =sum(if(field1 = calendar_field1,field_to_sum))

This works, but I believe that if I could replace it with set analysis it would be faster.

Any help?

ogster1974 — Thu, 03 Sep 2015 19:17:15 GMT

SUM({$ <[field1]=p([calendar_field1])>} field_to_sum) should work

m_woolf — Thu, 03 Sep 2015 19:46:40 GMT

I thought that I tried that, but I tried again and it worked. Thanks.

ogster1974 — Thu, 03 Sep 2015 19:48:12 GMT

No problem glad I could help.

chrisjad — Fri, 18 Mar 2022 21:38:42 GMT

How do you handle an AVG function with calendar Island?

For example, if a create a KPI to return an average of sales using the date from the calendar island, what would be the formula?