Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
PFA.......
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?
Hi,
PFA.........Is this ok
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