Discussion Board for collaboration regarding Qlik DataMarket.
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.
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...
But m not getting right data corresponding to the onsite as well as slight difference in offshore as well.
Would you be able to share a sample to show the issue?
i m afraid its confidential.
the issue is just in the values. and the sample is just like i shared.
I am afraid I don't understand what is not working . May be someone else can help
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?
yes we have tried and we are getting values very close to the correct answer but not the exact....
Thanks alot...it worked!
That means, The data may wrong when we pull the data from Source