error with set Analysis

[kris_vliegen]

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]

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]

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

}  >   }   Pump_price)

[kris_vliegen]

This isn't working.

This is what I have

[petter · Accepted solution]

Use single quotation marks:

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

[qlikmsg4u]

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]

Thanks All,

it is working!!