topic Re: Error garbage after expression ")" in QlikView

Error garbage after expression ")"

IE — Mon, 26 Jan 2026 18:19:17 GMT

I have a problem with a expression that works perfectly in a chart but not in a pivot or straight table.

=Sum({<Tipo={"Venta"}>} $(Category))

The variable Category is selected in an Imput Box and the list of fields is:

[FSC Recycled Credit];[FSC Mix Credit];[FSC Controlled Wood];[No Certificado]

The error gives me is Error garbage after expression ")"

Could somebody help me?

Thanks in advance

Re: Error garbage after expression ")"

Vishal_Gupta — Sat, 05 Mar 2022 09:32:20 GMT

Can you also show your expression for variable?

Re: Error garbage after expression ")"

MadhuriReddy — Sat, 05 Mar 2022 10:44:20 GMT

Hello,

Try this:

=Sum({<Tipo={"Venta"}>} '$(Category)')

Re: Error garbage after expression ")"

IE — Sat, 05 Mar 2022 12:34:50 GMT

The problem follows with Sum({<Tipo={"Venta"}>} '$(Category)').

I attach the way to create the variable that select some fields in the script.

In the list is [FSC Recycled Credit];[FSC Mix Credit];[FSC Controlled Wood];[No Certificado]

Re: Error garbage after expression ")"

marcus_sommer — Sat, 05 Mar 2022 12:44:37 GMT

Your approach will work within the table, too. But it looked that you misspelled the variable. In your expression you name it Category and within the input-box the name is Categoria.

- Marcus

Re: Error garbage after expression ")"

IE — Sat, 05 Mar 2022 13:04:02 GMT

I traslated the name for understanding.

With Categoria is the same.

It is not the problem.

It is very rare, because in a bar chart the expression works, but in the pivot and straigh table, not.

Re: Error garbage after expression ")"

IE — Sat, 05 Mar 2022 21:54:29 GMT

Sorry. it is solved.

I was eliminating the dimensions one by one untill the problem desappeared.

The problem is the field Categoria as dimension.

I changed it as variable in the dimension and all works.

Re: Error garbage after expression ")"

Vijayqlik4171 — Sun, 06 Mar 2022 04:56:18 GMT

Add any dimension in pivot table and write measure in =Sum({} Category)