topic Need help in expression in QlikView

Need help in expression

Thu, 12 Jul 2012 13:10:21 GMT

Dear Friends,

I am using QV 10 and in a pivot table i have written a expression like the following

=If([Statement Number]>1,Count([Transaction Reference]),0) but the total as well as partial sum shows as 0 only.

Is it possible to show the total of the expression.

Regards

Chriss

Thu, 12 Jul 2012 13:13:45 GMT

use count(if.... instead of if(count

this will help

Thu, 12 Jul 2012 13:19:10 GMT

Hello Arasu,

Thanks for your reply, I tried with count(If....), could you please help me further.

Regards

Chriss

MayilVahanan — Thu, 12 Jul 2012 13:24:46 GMT

Hi,

Try this,

=Count({< [Statement Number] = {">1"} > } [Transaction Reference])

Refer the data once, is there any "Transaction Reference" data is greater than 1 for statement number..

Can you post a sample file..

Hope it helps..

Thu, 12 Jul 2012 13:28:48 GMT

try this:

If([Statement Number]>1 or rowno()=0,Count([Transaction Reference]),0)

Thu, 12 Jul 2012 13:48:49 GMT

Hi,

Your expression works exactly...

Regards

Chriss