Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I need help in an issue ,the issue is like i have a report in which i have to get the summation of a column which i am using in other column.I have a column in which i have calculated some value and then show the summation at the top of the column now i want to use this summation in other column as i have to divide each row of that column with this summation.
Please reply it is very urgent.
Thanks in advance
Ferha Jafri
Please see the attached sample
Hi can you post sample here so we can help you. sample qvw would help (qlikview application that contains a sample of your problem).
Hi,
u can use " Total" keyword in side the sum then we will get summation of that perticular entire column summation.
=sum(Total fieldname).
This expression u can use in second column, means where u want to do division.
Thanks,
Ashok.
No values are not coming when i am typing in this way ,here we are using qlikview 9
Anybody have any idea how to evaluate this issue.
What ashok said is correct (you will need to use total function). But his sample is for basic sum only since you didn't give any sample yourself.
Good luck
Please see the attached sample
This what i am looking for but it is qlikview 9 so are u sure that we have this function in this.
If not greatly mistaken, it is there. Why don't you try yourself and confirm ?
Thank you so much Tresesco