topic Re: Pivot table total in QlikView

Pivot table total

Anonymous — Sat, 06 Dec 2014 11:37:10 GMT

Here at the final performance i want the sum of the above and i want to remove the value at {111} at performance.

ecolomer — Sat, 06 Dec 2014 11:43:18 GMT

You can put the colour of text at the same colour of the background

Anonymous — Sat, 06 Dec 2014 11:58:30 GMT

how can we write the code for that total field particularly and the sum at final performance also

ecolomer — Sat, 06 Dec 2014 12:08:24 GMT

Can you upload the file?

Anonymous — Sat, 06 Dec 2014 12:20:14 GMT

can u come to team viewer .

ecolomer — Sat, 06 Dec 2014 12:24:12 GMT

ok,

send me your usr/pswd

Anonymous — Sat, 06 Dec 2014 12:29:18 GMT

192 118 270

rrv784

ecolomer — Sat, 06 Dec 2014 12:30:24 GMT

I'm going

ecolomer — Sat, 06 Dec 2014 13:06:09 GMT

Here you have an example.

The totals are Dimensionality() function = 0 and you can put colour for text and backgroud equal to not see

Sorry for my english

ecolomer — Sat, 06 Dec 2014 13:11:14 GMT

Anonymous — Sat, 06 Dec 2014 13:26:43 GMT

how can i write the expression over there ??

ecolomer — Sat, 06 Dec 2014 13:48:19 GMT

This is an example.

You need this expressions:

- In the blackground ... if(dimensionality()=0, grey())

- In the text ... if(dimensionality()=0, grey())

This expressions in each column you need to not see

ecolomer — Sat, 06 Dec 2014 13:53:43 GMT

the example