The expression not working with the filter selection .

[suvechha_b]

Hi All ,

Please advise  The ecpression is not working accordingly.The Prev 3 month Unit Sales is same for both plant_code_name .

Sample attached.

[stabben23]

Hi,

if you have a look into Your datamodel you will find that "Amout" which is the Field you use is not Connected to the Dimension you use in the Pivot. You have what I can see a lot of work With Your datamodel if you want a "best practise" qlikview model.

[stabben23]

The Field Amout is from a "DataIsland"

[suvechha_b]

My actual datamodel is below :

I think the dataIsland happened because I reduce the data . to build sample model. My original model is huge.

[stabben23]

Ok, This is for me a model With circular Reference or Is it a illusion?

I can not help if you send a qvw without correct datamodel.