Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

panipat1990
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
sunny_talwar
Not applicable

Re: To calculate Total of % values

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

panipat1990
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

sunny_talwar
Not applicable

Re: To calculate Total of % values

What is the expression you are using currently?

panipat1990
Not applicable

Re: To calculate Total of % values

Avg(%Value)

sunny_talwar
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?

panipat1990
Not applicable

Re: To calculate Total of % values

Yes, that i know...

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

sunny_talwar
Not applicable

Re: To calculate Total of % values

AFAIK, I doubt that it is possible

panipat1990
Not applicable

Re: To calculate Total of % values

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

Thanks

Gourav

sunny_talwar
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