Error in expression: ')' expected

[TomBond77]

Hi experts

This formula gives an error:  Sum([Group]={'General','Cars','Bikes','Houses'} [Total Stock])

It says: Error in expression: ')' expected

Where is the problem? Brackets should be fine.

Thanks for any help.

Tom

[Taoufiq_Zarra]

@TomBond77  like :

Sum({<[Group]={'General','Cars','Bikes','Houses'}>} [Total Stock])

if you have [Total Stock] field if not maye be you want :

Sum({<[Group]={'General','Cars','Bikes','Houses'}>} Total [Stock])

[Qlik1_User1]

@TomBond77 ,Try this

SUM({<[Group]={'General','Cars','Bikes','Houses'}>} [Total Stock])

[TomBond77]

Hi, I don't see any difference to my formula. Or am I blind? 😉

[TomBond77]

Hi Taoufiq 

"Total Stock" is one measure. 

Do you other way of solution?

Rgds

Tom

[Taoufiq_Zarra · Accepted solution]

Hi @TomBond77  the difference :

Sum({<[Group]={'General','Cars','Bikes','Houses'}>} [Total Stock])

if it doesn't solve the problem maye be can you share a sample data and the expected output