Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Expression value should not change on adding new dimesnsion

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

Tags (1)
8 Replies
MVP & Luminary
MVP & Luminary

Re: Expression value should not change on adding new dimesnsion

Try count(total <Month> DISTINCT Name)


talk is cheap, supply exceeds demand
Employee
Employee

Re: Expression value should not change on adding new dimesnsion

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

balrajahlawat
Esteemed Contributor

Re: Expression value should not change on adding new dimesnsion

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?

Not applicable

Re: Expression value should not change on adding new dimesnsion

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.

Not applicable

Re: Expression value should not change on adding new dimesnsion

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.

Not applicable

Re: Expression value should not change on adding new dimesnsion

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

balrajahlawat
Esteemed Contributor

Re: Expression value should not change on adding new dimesnsion

will this work?

Employee
Employee

Re: Expression value should not change on adding new dimesnsion

Maybe I am not understanding your need.

It seems to work here

Capturar.PNG