topic Using nested if statement and set analysis in expression- Not able to get Expression total. in QlikView

Using nested if statement and set analysis in expression- Not able to get Expression total.

Anonymous — Fri, 05 Aug 2011 19:58:15 GMT

Hello All,

I'm using a 20 line nested if statement and set analysis with in it in an expression for Column A.

I'm using Expression total and not able to get total for Column A it shows '-' .

I don't wana use Sum of rows as I need a Column D = Total (Column A) / Total(Column C) .

I need ARPPU($) value as 20.9 which would be Column D = Total (Column A) / Total(Column C) .

Any help would be appreciated.

johnw — Fri, 05 Aug 2011 20:14:22 GMT

OK, so you don't want sum of rows, and you don't want expression total. What DO you want?

From the value you want in ARPPU ($), I guess you want 20.9 * 180003 = $3,762,062.70 in Sales ($)? And where is that number supposed to come from?

Anonymous — Fri, 05 Aug 2011 20:26:18 GMT

Hi John,

Sum of rows works fine , I actually want expression Total, when I set to Expresssion total its giving me blank total for column A.

Then I want to get that column A Expression total / Column C Expression total for ARPPU Total which is 20.9.

Hope you understand the scenario.

Anonymous — Fri, 05 Aug 2011 20:27:03 GMT

Hi John,

Sum of rows works fine , I actually want expression Total, when I set to Expresssion total its giving me blank total for column A.

Then I want to get that column A Expression total / Column C Expression total for ARPPU Total which is 20.9.

Hope you understand the scenario.

Anonymous — Fri, 05 Aug 2011 20:28:22 GMT

Sum of rows works fine , I actually want expression Total, when I set to Expresssion total its giving me blank total for column A.

Then I want to get that column A Expression total / Column C Expression total for ARPPU Total which is 20.9.