topic Difference b/w Set Analysis & If in QlikView

Difference b/w Set Analysis & If

Tue, 17 Aug 2010 06:54:57 GMT

Hi,

The functioning of these two expressions gives different result..Can Anyone help me to figure out?

sum( {$<Time={"<=$(TimeCount)"}>} [# of Checks] )

sum(if (Time <= $(TimeCount),[# of Checks]))

Difference b/w Set Analysis & If

Tue, 17 Aug 2010 07:07:11 GMT

Hi Blessy,

Both these expressions should return the same value. I am not sure why it gives different values.

I doubt, this might be due to the data type of the field 'Time'. Can you update the variable definition by including the data type of the field 'Time' and check if it works.\

Difference b/w Set Analysis & If

Tue, 17 Aug 2010 07:23:56 GMT

Try this Actually set functions checks conditions first then makes aggregation sum( {$} [# of Checks] ) so the equivalent if statement for above expression would be if (Time

Difference b/w Set Analysis & If

Tue, 17 Aug 2010 07:43:04 GMT

Try this Actually set functions checks conditions first then makes aggregation sum( {$} [# of Checks] ) so the equivalent if statement for above expression would be if (Time

Difference b/w Set Analysis & If

llauses243 — Tue, 17 Aug 2010 09:17:21 GMT

sum(if ... func in all version

sum($ ... Func in V9 no func in other version, return null

Difference b/w Set Analysis & If

johnw — Tue, 17 Aug 2010 22:32:54 GMT

The original expressions do have different meanings. The set analysis expression OVERRIDES the selection in Time. The if() respects selections in Time. So if any Times are selected, that could cause you to get different results. To make the expressions return exactly the same value in all cases would be this, I believe:

sum( {<Time*={"<=$(TimeCount)"}>} [# of Checks] )
sum(if(Time <=$(TimeCount), [# of Checks]))