topic Re: error with set Analysis in QlikView

error with set Analysis

kris_vliegen — Tue, 25 Aug 2015 11:41:49 GMT

Hi All,

I have a problem with set analyses.

If I use this =avg( { $ < Site_Id_Name = { $(vEigenStation) } > } Pump_price)

I get an error "Error in set modifier ad hocelement list"

If I use this =avg( { $ < Site_Id_Name = { " $(vEigenStation)" } > } Pump_price)

I don't get a value

who can help me?

Regards,

Kris

kaushiknsolanki — Tue, 25 Aug 2015 11:46:28 GMT

Hi,

Second one is the correct one.

Make sure the variable is holding a proper value before passing to the set analysis.

Regards,

Kaushik Solanki

sasiparupudi1 — Tue, 25 Aug 2015 11:49:20 GMT

avg( { $ < Site_Id_Name = { "$(=$(vEigenStation))"

} > } Pump_price)

kris_vliegen — Tue, 25 Aug 2015 12:00:23 GMT

This isn't working.

This is what I have

petter — Tue, 25 Aug 2015 12:02:07 GMT

Use single quotation marks:

If I use this =avg( { $ < Site_Id_Name = { '$(vEigenStation)' } > } Pump_price)

qlikmsg4u — Tue, 25 Aug 2015 12:04:15 GMT

avg( {$<Site_Id_Name = {"ESSO EXPRESS WOMMELGEM (75)"} >} Pump_price)

check this and let us know if it is working

PS:change the text in bold to your original value because it may contain typo errors

kris_vliegen — Tue, 25 Aug 2015 12:26:56 GMT

Thanks All,

it is working!!