How to use Set Analysis based on graph dimension?

isorinrusu — Wed, 22 Jul 2015 06:46:16 GMT

Hi everyone,

I have two calendars, one for services and one for employers. I have a linechart that shows the evolution of services (dimension being year month from the service's calendar), and I'd like to also show the number of employers for each existing year month in the x dimension.

So, I'm trying to use Set Analysis, but in vain. The expression I use is the following:

count({< AñoMes={'$(=only(ServAñoMes))'}, Mes=,Año=>} DISTINCT total DNI)

AñoMes being the employers' Year Month from its calendar, and ServAñoMes being from the services' calendar, used as a dimension in the graph.

Does this have any solution at all?

The second thing I've tried is to have a variable that takes its first parameter as the AñoMes value. But it's still not working because it won't take the only(ServAñoMes) as its parameter.

PS: Building only one calendar (or Master Calendar) is not feasible due to the data associations.

Thank you in advance.

Re: How to use Set Analysis based on graph dimension?

Wed, 22 Jul 2015 10:50:14 GMT

Can you upload a sample file for better understanding and quick resolution?

Regards,

KKR

Re: How to use Set Analysis based on graph dimension?

isorinrusu — Thu, 23 Jul 2015 12:30:14 GMT

Hi KKR,

The problem has been solved, thanks

topic Re: How to use Set Analysis based on graph dimension? in QlikView

How to use Set Analysis based on graph dimension?

Re: How to use Set Analysis based on graph dimension?

Re: How to use Set Analysis based on graph dimension?