Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

divyanshi
New Contributor II

how to divide the individual column value by its total column value??

Untitled.png

I need to calculate the values for the column named %.

I need the values corresponding to each date values.

the logic to calculate is Headcount/sum(Headcount)

Eg. 10/400 for offshore and 5/10 for onsite and so on..corresponding to all the date value.

I m  getting the valid data as per my logic.

Kindly guide me.

Tags (2)
10 Replies

Re: how to divide the individual column value by its total column value??

Try this

Sum(Headcount)/Sum(TOTAL <OFFSHORE/ONSITEdimensionHere> Headcount)

I am guessing this is a pivot table with OFFSHORE and ONSITE is part of a dimension which is pivoted...

pooja821
New Contributor III

Re: how to divide the individual column value by its total column value??

Thanks Sunny!

But m not getting right data corresponding to the onsite as well as slight difference in offshore as well.

Re: how to divide the individual column value by its total column value??

Would you be able to share a sample to show the issue?

pooja821
New Contributor III

Re: how to divide the individual column value by its total column value??

i m afraid its confidential.

the issue is just in the values. and the sample is just like i shared.

Re: how to divide the individual column value by its total column value??

I am afraid I don't understand what is not working . May be someone else can help

Re: how to divide the individual column value by its total column value??

Have you tried at least? Because, It's looks like you may not understand the expression.

You must use your setting up of your fields rather Headings?

Life is so rich, and we need to respect to the life !!!
divyanshi
New Contributor II

Re: how to divide the individual column value by its total column value??

yes we have tried and we are getting values very close to the correct answer but not the exact....

pooja821
New Contributor III

Re: how to divide the individual column value by its total column value??

Thanks alot...it worked!

Re: how to divide the individual column value by its total column value??

That means, The data may wrong when we pull the data from Source

Life is so rich, and we need to respect to the life !!!
Community Browser