topic How to write expression in dimension = that dimension/total sum in QlikView

How to write expression in dimension = that dimension/total sum

Thu, 24 Nov 2011 19:44:15 GMT

Hello,

I am having a problem with pivot table.

How can I write an expression to show a value in each dimension = its own value / total partial sum in that dimension.

Would be much appreciated if anybody answer......

How to write expression in dimension = that dimension/total sum

ToniKautto — Thu, 24 Nov 2011 19:51:34 GMT

Please provide exaple data and a sample of what you expect your pivot table to look like. To exemplify the pivot you could for exampl stage a excel sheet as mockup of your expected pivot.

How to write expression in dimension = that dimension/total sum

Thu, 24 Nov 2011 20:11:58 GMT

Hello,

This is how it looks like. Value in table #TTD derives from Count(ApplicantID)

I'd like to create table %TTD Distribution. The value derives from this formula:

Count(ApplicantID) * 100 / Total in table #TTD

For example, value for New to Bank in 31/01/2011 is

33.3333 = (2*100) / 6

Hope this is clear enough....

I use Partial Sum function and not sure how to write its expression.

Thanks a lot in advance..

How to write expression in dimension = that dimension/total sum

Thu, 24 Nov 2011 21:02:57 GMT

Your expression should be :

=Count( ApplicantID) /Count(TOTAL <Date> ApplicantID)

How to write expression in dimension = that dimension/total sum

Thu, 24 Nov 2011 21:13:00 GMT

Alright it works, thanks a lot..