columns

[raadwiptec]

hi all,

is there any way to add columns and get the total as in red

example as below. in red

the price is an expression.. not a dimension...

Jan	feb	mar
product	price	price	price	total
a	10	10	10	30
b	20	20	20	60

[nagarjuna_kotha]

Hi Raadwiptec,

In Expression Tab of your chat.Expand your total expresion >>In Text Colour .Put >>> =Red()

[sunny_talwar]

Don't hesitate to experiment in QlikView. You never know what great new tricks you'll discover.

A very useful advice Peter‌ . I love experimenting because the worst that can happen is that the experiment won't work, but the best things is the satisfaction I get when it actually does work after 15-20 trials.

[Peter_Cammaert]

I'm getting the expected result if I enable Partial Sums for Dimension Month:

[nagarjuna_kotha]

Like this you want ?

PFA....

[raadwiptec]

Hi Peter,

This is perfect. Iam getting the desired results. But iam not able to move the Total colums to the end...

[rubenmarin · Accepted solution]

Hi, about the colour in the expressions tab, expand the expression to set color to lightred:

And about the totals, in presentation tab, check subtotals down.

[Peter_Cammaert]

In the Object Properties->Presentation tab, select the correct subtotals position in the Subtotals group (middle right). There are two values that correspond to positions for vertical dimensions (totals at the top or the bottom). If you turned your dimension into a horizontal one, top becomes LEFT and bottom becomes RIGHT.

Select the bottom position for your Month dimension. Your totals column will then show up on the right end.

Note that if you have monre dimensions stacked on top of each other, the subtotals will be repeated for every value of a higher dimension.

Peter

[raadwiptec]

yes the solution is put the totals down and do as peter mentioned for totals.

Thanks all