topic distributing values to dimensions in QlikView

distributing values to dimensions

Thu, 05 Apr 2012 06:44:15 GMT

Hi all,

could somebody tell me, what is the best way to distribute values from one dimension to the others:

Just here my problem:

I have 7 dimensions: Admin, pumps....Warehouse with different values behind.

Now I want to distribute the value of warehouse of "459.073" e.g. to 10% to the dimension "pumps", 20% to G&W and so on.

Has somebody a good idea for that how to do that?

Thanks in advance

Regards Christoph

vijay_iitkgp — Thu, 05 Apr 2012 06:53:31 GMT

If it is one time requirement then do it at script klevel and create new column at backend.

Regards

VIjay

Thu, 05 Apr 2012 06:55:56 GMT

Hi,

thank you, but could you please specify a little bit?

Regards Christoph

Thu, 05 Apr 2012 08:47:47 GMT

Hi, has someone else a good and perhaps simple idea?

Rgds CH