Using a free floating calender referencing to another calender to get values but have problem

Nocto — Wed, 25 Nov 2020 16:16:04 GMT

Hey guys hopefully you can help me out,

I am using a Free Floating calender, because I have Createtimes and Change times.

Because of that I use this set Analysis to get the Right Values:

Aggr( count({< DateNum..change_time_ticket_Cal = p(DateNum..FreeFloating), id..ticket_state_ticket = {2,3,9,10,11} >} id..ticket), MonthYear..FreeFloating)

My Dimension is MonthYear..FreeFloating

Right now I have the Problem when I am Creating a Chart that when I am using a Free Floating Calender to reference to a changetime Calender to get the values that I want for example March it works. then I get

But when I select more than 1 Month i get the sum of every selected Month.

I checked if a activated some Kind of Settings but I did not, so i cant understand why i get this result.

Re: Using a free floating calender referencing to another calender to get values but have problem

marcus_sommer — Wed, 04 Nov 2020 13:03:34 GMT

It seems that your datamodel isn't suitable for your wanted views. It's not clear for me what do you mean with a free floating calendar and how it is associated to your other calendar and the other tables from your datamodel.

I suggest to take a look to a canonical calendar: Canonical-Date

- Marcus

topic Using a free floating calender referencing to another calender to get values but have problem in QlikView

Using a free floating calender referencing to another calender to get values but have problem

Re: Using a free floating calender referencing to another calender to get values but have problem