Hi! I'm still quite new to Qlikview and learning as I go along so I'm sorry if this is really obvious but I couldn't find an answer!
I basically want my OL Spend expression to bring back either the Cons OL, Spares OL etc. depending if the CCOA of Cons, Spares etc. is selected. (I hope that makes sense). I've attached a little QV of what the layout is to make it clearer.
Due to the way my actual QV is, the actual sales is split fine like this in lots of different data then mapped up to the correct CCOA but the OL is just a one line excel sheet and causes loops if I add the CCOA column but creates duplicate lines if I try and map it to the CCOA... So this seemed like the only way!
Anything else you need let me know and thank you so much in advance!!!