topic Re: Set analysis on possible values in QlikView

Set analysis on possible values

qw_jakub — Thu, 12 Sep 2013 14:20:45 GMT

Hello,

I need two calendars to be alway set on the same days. I can not use just one, because it creates a loop.

The user should filter in Calendar_1 and Calendar_2 should be automitaclly filtered in the same way

I have tried a set expression like this:

= count({$<[Date_Calendar_2] = [Date_Calendar_1]>} distinct item_id) ,

but this works only if the user selects a date in Calendar_1 not if he selects a Month, or a Year.

Is there a way to make a set of dates in Calendar_2 of all possible dates values in Calendar_1?

Thanks for any tips!

swuehl — Thu, 12 Sep 2013 14:25:46 GMT

have you tried this?

= count({$<[Date_Calendar_2] = p( [Date_Calendar_1] ) >} distinct item_id)

qw_jakub — Thu, 12 Sep 2013 14:29:19 GMT

Thanks, this was it. I just recalled the p idenitfier myself.

This works.