Total Population not correct!!

[danielgargiulo]

HI All,

I am having trouble with QlikView where it seems to be excluding values from a total calculated of a linked table when there is no associated values in the main table. I have attached an example QVW which outlines the problem in more detail and shows some of the variations i have tried/ I thought this would be very straight forward but I cant seem to crack it.......

Your help will be much appreciated,

Dan

[#2]

Hi,

PFA.......

[danielgargiulo]

thanks for the quick reply, I would like Spec 1 and Spec 2 to have the same value, eg for DHB 1 it should be the same 1453 for both spec 1 and spec 2. does that make sense?

[#4]

Hi,

PFA.........Is this ok

[danielgargiulo]

HI NIrmal,

This is not the outcome i require sorry. I would like something along the lines of the table below:

DHB , Spec , Population

DHB 1 , Spec 1, 1453

DHB 1, Spec 2, 1453

DHB 2 , Spec 1, 433

DHB 2, Spec 2, 433

thanks again for your help

dan