topic Re: Expression Help in QlikView

Expression Help

Anonymous — Tue, 20 Jan 2015 18:31:59 GMT

I need a little bit of help editing an expression. Attached you'll see and image of two straight tables. In the second table, I've removed one employee category by putting a dimension in the expression

But the issue that I'm having now is that the formulas are still adding up all of the categories, instead of what is showing in the second document. I suspect that there is some kind of Aggr that needs to be put in.

Employee Count expression is sum([Employee Count])

% of EE total expression is sum([Employee Count])/sum(TOTAL([Employee Count]))

Can anyone help me out? Thanks!

Re: Expression Help

chrismarlow — Tue, 20 Jan 2015 19:09:16 GMT

Are you saying you want to exclude one 'Employee Department', in which case would a set {<[Employee Department]-={'xxx'}>} do it?

Re: Expression Help

Anonymous — Tue, 20 Jan 2015 20:12:08 GMT

Chris,

The point of the two charts is essentially to present the employee counts based on department - one with and one without HDS, rather than having someone have to actively select them from a list box.

I've already excluded the employee department in the second table by a simple =if([Employee Department]<>'
HDS',[Employee Department]).

What is happening that I wasn't expecting, is that when calculating the % of total, it's still counting the HDS data. I'm afraid I'm not versed in Set Analysis enough to understand a lot of that yet.

Re: Expression Help

chiru_thota — Tue, 20 Jan 2015 20:29:43 GMT

Exclude that department in bot numerator & denominator of % EE Metric also.

Otherwise upload your QVW.

Re: Expression Help

Anonymous — Tue, 20 Jan 2015 20:42:31 GMT

uploaded

Re: Expression Help

chiru_thota — Tue, 20 Jan 2015 20:48:39 GMT

sum({<[Employee Department]-={'Help Desk Services'}>}[Employee Count])

/sum({<[Employee Department]-={'Help Desk Services'}>}TOTAL([Employee Count]))

Re: Expression Help

Anonymous — Tue, 20 Jan 2015 20:55:26 GMT

Awesome. Thanks!