topic Re: write a condition for total row in QlikView

write a condition for total row

Mon, 25 Nov 2013 07:04:16 GMT

Hi,

there is direct option for total row but i want to write a condition for that totals row so is it possible.

Mon, 25 Nov 2013 07:20:11 GMT

Hi,

Yes. It can be possible but depends on your condition also. can your explain here which type of condition you want for total?

Thanks,

Ashutosh

jagan — Mon, 25 Nov 2013 07:26:49 GMT

Hi Pankaj,

Try like this

=If(RowNo() = 0, 'Your Expression goes here', Sum(Measure))

RowNo() = 0 -- Belongs to total row

Regards,

Jagan.

tresB — Mon, 25 Nov 2013 07:34:39 GMT

If you are there in pivot table, try using dimensionality() function.