# QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Not applicable

## To calculate Total of % values

Dear Team,

we have % values coming from back-end script. we are showing that value in Straight table but not able to show total of all % values.

Could you please help us to get total of % values in straight table. for this , have shared the data set with it.

Kindly check and suggest us the best solution if possible.

Thanks

Gourav

12 Replies
Not applicable

## Re: To calculate Total of % values

What is your current expression and have you enabled total for the %Value expression?

Not applicable

## Re: To calculate Total of % values

Hi Sunny,

yes that total mode is enabled.

i just want to know what formula we can write to show % value on straight table with the total % value on TOP row.

Thanks

Gourav

Not applicable

## Re: To calculate Total of % values

What is the expression you are using currently?

Not applicable

Avg(%Value)

Not applicable

## Re: To calculate Total of % values

I think you will need to use the other two fields instead of using your pre-calculated %Value field to do this. Is that okay? If it is can you provide the first two expression used?

Not applicable

## Re: To calculate Total of % values

Yes, that i know...

but can we calculate % on pre-calculated %value field?

Not applicable

## Re: To calculate Total of % values

AFAIK, I doubt that it is possible

Not applicable

## Re: To calculate Total of % values

okey.. then..can you ask to someone other in your circle please.

Thanks

Gourav

Not applicable

## Re: To calculate Total of % values

my circle? Gourav, like I said I don't think this is possible. If someone disagrees with me, he/she will respond right here. I don't have the time to go about ask around my friend. I am sorry if that's not what you expected.

Best,

Sunny

Community Browser