topic Re: Perform an average in script if in QlikView

Perform an average in script if

Anonymous — Tue, 10 Dec 2024 14:35:26 GMT

Hi,

I want a new field that returns the average (n) if 'Apple' appears in the field value, otherwise return 'n'. I just can't figure it out.

Many thanks

Re: Perform an average in script if

Or — Tue, 10 Dec 2024 14:44:45 GMT

Average of what? What is n? Your sample doesn't really explain what the incoming data and expected outcome are.

Re: Perform an average in script if

NoahF — Tue, 10 Dec 2024 19:41:26 GMT

If I understand your desired output correctly, then you could calculate the average(n) first and store it in a variable. Then you can load your entire table and decide with the wildmatch() function, if the Field includes the word '*Apple*', and save either the value of n or the avg(n) from the variable.

Data: LOAD * INLINE [ Field, n Green Apple 1, 6 Red Apple 2, 8 Pear 3, 4 Orange 2, 7 Pear 1, 5 ]; Temp: LOAD AVG(n) AS AvgN RESIDENT Data; Let vAverage = Peek('AvgN'); Avg: LOAD *, IF(WildMatch(Field, '*Apple*'), $(vAverage) , n) AS New_Field RESIDENT Data; Drop Table Data, Temp;

Output Tabel:

Re: Perform an average in script if

Anonymous — Wed, 11 Dec 2024 10:35:57 GMT

Thank you so much!