Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
blunckc1
Not applicable

Error in expression help!

Hi guys,

Can someone help me with the following expression as I am getting a ')' expected result.

PostCode&' - '&if(count({<AgeGroup={"0-14"}>} DISTINCT PID)>10,'Over '&count({<AgeGroup={"0-14"}>} DISTINCT PID)&' Employees',Concat(Employee Name,' | '))&' - (Age Group 0-14: '&sum({<AgeGroup={"0-14"}>} Population)&')'

Thank

3 Replies
sushil353
Not applicable

Re: Error in expression help!

Try this:

=PostCode&' - '&if(count({<AgeGroup={"0-14"}>} DISTINCT PID)>10,'Over '&count({<AgeGroup={"0-14"}>} DISTINCT PID)&' Employees',Concat(Employee Name,' | '))&' - '&'(Age Group 0-14: '&sum({<AgeGroup={"0-14"}>} Population)&')'

HTH

Chanty4u
Not applicable

Re: Error in expression help!

missing her   give one more brace

Over '&count(({<AgeGroup={"0-14"}>} DISTINCT PID)&

sunny_talwar
Not applicable

Re: Error in expression help!

May be this:

PostCode & ' - ' &


(If(Count({<AgeGroup={"0-14"}>} DISTINCT PID) > 10,


('Over ' & Count({<AgeGroup={"0-14"}>} DISTINCT PID) &' Employees'),


Concat(Employee Name,' | ')))


& ' - (Age Group 0-14: ' & Sum({<AgeGroup={"0-14"}>} Population) & ')'