Expression not recognising dimension despite P()

[#1]

can you please look at the 2nd expression. I expect it to respect the dimension in iteration in terms of the P() function. But it doesn't. Can someone help?

Thanks,

Ram

[jonathandienst]

It is slow performing because there is no association between the 2 tables, so QV has to do a cross-join (aka Cartesian join) to perform this filtering. This kind of operation is only practical for small data sets.

As Daniel suggested, the solution is to associate the tables by loading t_segment_code as segment code. If you cant make that change, then you will not be able to do the chart in your post.

[#3]

YES Jonathan, I realise it doesn't scale for high data volumes at all as if statements are single threaded. I am trying to see what i can do with the data model with least possible regression effects.