topic Re: calendar as data island in QlikView

calendar as data island

m_woolf — Fri, 04 Sep 2015 12:12:36 GMT

I'm reposting this because I thought it was solved and marked it as Answered. Now the original discussion is locked.

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?

Andy Weir replied:

Andy Weir Sep 3, 2015 3:17 PM (in response to M Woolf)

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

I found that this works in a text box when I select some calendar dates, but it does not work in a chart with calendar date as the dimension. It looks like it doesn't aggregate by the dimension. I tried adding aggr to my expression, but no joy.

Re: calendar as data island

alexandros17 — Fri, 04 Sep 2015 12:16:45 GMT

But what is the use of a calendar unlinked to other dates?

Re: calendar as data island

m_woolf — Fri, 04 Sep 2015 12:39:11 GMT

Suppose I have 6 different charts. Each is based on a different date field.

I can use: =sum(if(field1 = calendar_field1,field_to_sum))

as the expression for each chart where field1 is a different date field for each chart. The same calendar can be use to filter all the charts.