topic Set Analysis in Gauges in QlikView

Set Analysis in Gauges

buddhabang — Mon, 26 Mar 2012 22:50:34 GMT

Hi,

I had a question if anyone could please help me with a set analysis i'm using in a gauge. I have a list of departments and calculated the number of employees in each one of these and wanted to get the ratio per dpt. My problem is this following set A in the gauge expression that only works for just the marketing dpt:

(count({$<Department={Marketing}>}Employee_ID)*100)/count(DISTINCT Employee_ID)

I want to be able to get the ratio for each individual department. Any help would be much appreciated.

Thanks

Set Analysis in Gauges

Mon, 26 Mar 2012 23:35:14 GMT

You could use trellis (in the dimension tab) and add Department as a dimension. Erase the set analysis.

Set Analysis in Gauges

buddhabang — Tue, 27 Mar 2012 09:38:23 GMT

Thanks Levi, not sure about Trellis, never came across it. Thanks for looking into it

Set Analysis in Gauges

Tue, 27 Mar 2012 15:46:13 GMT

Take a look at it, I think is by far the best solution

Set Analysis in Gauges

Tue, 27 Mar 2012 15:57:34 GMT

If your Department resides in the same table as Employee_ID what you could do is create a listbox with the Department, then check the box Show Frequency and In Percent

Set Analysis in Gauges

buddhabang — Tue, 27 Mar 2012 16:18:59 GMT

Thanks guys for taking the time to look into this. First Levi, i've done exactly that unfortunately when i delete the set analysis in the expression after using Trellis, i get "All expressions disabled" as a result. But when i do leave the set analysis i get all the gauges from each dept using Trellis which by the way i like very much, so thanks, but still the calculations are incorrect. My problem i beleive is the set analysis, any ideas.

Marc, that was kind of you, already knew that

Re: Set Analysis in Gauges

Tue, 27 Mar 2012 16:27:33 GMT

Could you upload your qvw to work directly on it?

The idea is like this:

Re: Set Analysis in Gauges

buddhabang — Tue, 27 Mar 2012 16:51:27 GMT

Thanks Levi, i'll check it tomorrow at work i'm at home now. I've uploaded mine. Cheers mate.

Re: Set Analysis in Gauges

Tue, 27 Mar 2012 17:17:31 GMT

Here.

I make a text object to check and the numbers seem right.

Regards

Re: Set Analysis in Gauges

Tue, 27 Mar 2012 17:19:57 GMT

What numbers are you expecting? I may be confused to what you are looking for.

Take a look at this. Your gauges seem to be set to 100 where percent is in decimals. Changing limits to reflect that is one of the things I changed

Re: Set Analysis in Gauges

buddhabang — Tue, 27 Mar 2012 17:24:10 GMT

Cheers Mark, i will check this tomorrow at work, i'm using the PE at the moment at home. Thanks a lot guys for your help.

For the numbers i use in the text in chart expression field:

=num((count({$<Department={Marketing}>}Employee_ID)*100)/count(DISTINCT Employee_ID),'#.##')&'%'

Nice one

Re: Set Analysis in Gauges

buddhabang — Thu, 29 Mar 2012 11:45:41 GMT

Thanks guys for helping me out with this, i really appreciate it.

Cheers.