topic Re: Show only total in straight table in QlikView

Show only total in straight table

Wed, 19 Mar 2014 11:02:48 GMT

Hello everyone,

I'm trying to create monthly bonus report. Is there a way to show only total value in column 2 (Net Fixed Payroll), which is Net Fixed Payroll for Month in column 1 of some salesperson. I also want to sum total value from column 2 and column 7 and show it in column 8

like in the picture below.

I attach excel table like a example.

Any help means a lot. Thanks

Re: Show only total in straight table

PrashantSangle — Wed, 19 Mar 2014 11:14:46 GMT

Hi,

I am not sure about your 2 requirement but you can achieve your first requirement by,

Go to Chart Properties->Expression->select your expression->Total Mode->select Expression Total or (Sum) of Rows.

and select No Totals for those expression which you don't need to show total,

Regards,

Re: Show only total in straight table

Wed, 19 Mar 2014 11:35:39 GMT

Thanks max for your answer, but I need something else.

I want to show only total value of column 2 and other cell to have blank.

And in column 8 I need to sum total from column 2 and column 7 like in the picture or Excel.

Thanks

Re: Show only total in straight table

maxgro — Wed, 19 Mar 2014 11:47:44 GMT

in a straight table to hide text

click on + on the expression you want to hide and for text color use expression (adapt to your need)

if(Dimensionality()=1,argb(0,0,0,0), black())

example Sales EUR

Re: Show only total in straight table

maxgro — Wed, 19 Mar 2014 11:55:21 GMT

column(2) + column(7)

Re: Show only total in straight table

Wed, 19 Mar 2014 12:22:57 GMT

Thanks, it's perfect