topic Re: Expression value should not change on adding new dimesnsion in QlikView

Expression value should not change on adding new dimesnsion

Mon, 09 Nov 2015 10:39:03 GMT

Hi Team,

I have a situation, where if I add new dimension in tables, expression value should not change.

Like I am calculating Spend/Employee across 2 departments and in this case total spend has to be divided with total employees,

thus department in dimension should not affect my calculation of Count of Employee.

PFA the sample data.

Regards,

Navdeep

Re: Expression value should not change on adding new dimesnsion

Gysbert_Wassenaar — Mon, 09 Nov 2015 10:42:33 GMT

Try count(total <Month> DISTINCT Name)

Re: Expression value should not change on adding new dimesnsion

Clever_Anjos — Mon, 09 Nov 2015 10:43:00 GMT

count(Total <Month> DISTINCT Name) should handle your requirement

Re: Expression value should not change on adding new dimesnsion

Anonymous — Mon, 09 Nov 2015 10:47:22 GMT

You are talking about Selection of Department filter or addition of Department dim in table?

For Selection , we can by pass in SET.

if we are adding a dimension and expression value is not changing then what would be the advantage of adding?

Re: Expression value should not change on adding new dimesnsion

Mon, 09 Nov 2015 11:05:54 GMT

Hi Total <Month> is not solving the issue, I should be able to see all departments in table but all should have same value for same month in expression.

Re: Expression value should not change on adding new dimesnsion

Mon, 09 Nov 2015 11:07:24 GMT

Hi,

I am talking about adding new dimension Department in table, it's adding advantage is because I dont need headcount of department, I need overall headcount.

Re: Expression value should not change on adding new dimesnsion

Mon, 09 Nov 2015 11:08:12 GMT

Tried, not working. Could you please try it on attached qvw.

Re: Expression value should not change on adding new dimesnsion

Anonymous — Mon, 09 Nov 2015 11:12:33 GMT

will this work?

Re: Expression value should not change on adding new dimesnsion

Clever_Anjos — Mon, 09 Nov 2015 11:20:13 GMT

Maybe I am not understanding your need.

It seems to work here