topic Calculate # dimension rows per fact row in QlikView

Calculate # dimension rows per fact row

Thu, 24 Oct 2013 12:54:42 GMT

Hi,

Probably this is very easy, but for some reason I don't succeed in getting (in the load script) the number of matching dimension rows per fact row.

Example attached as well.

Any advice would be appriciated.

Maarten

Aurelien_Martinez — Thu, 24 Oct 2013 13:04:20 GMT

Hi,

See this QV file

Thu, 24 Oct 2013 13:11:07 GMT

Hi Aurélien,

That would indeed be a good solution if there was no need to calculate the result in the script.

In my case, the best solution would be to have the result as field value.

I can easily solve the problem by using an outer join, but I'm now sure what the impact will be in the real script.

E.g.

marcus_sommer — Thu, 24 Oct 2013 13:30:32 GMT

I think you could use table-functions like noofrows() for this.

- Marcus

Fri, 25 Oct 2013 06:06:23 GMT

In the end I was able to solve the problem with the following code.

Did some tests and the results seem to be ok.

Thanks for your feedback.