Document loading severely reduced after changing a pivot table
Despite my best efforts, I export the data in excel to hand out to many people in the company, however, what I have recently done was to remove some hard coding of accounts that have a particular flag.
This is how my data is set up (without going too much into detail)
Flag (1 or 0, did have it set to Y but changed it)
What I initially had was based on this, If accountkey = XX or accountkey = XY then Product Category (XXXX) else Product Category
But since changing it to a flag where it goes if flag > 0 it seems to be causing a massive problem on loading, i guess this is just too much for qlikview to handle or something?
Any suggestions would be greatly appreciated as i don't want to hardcode accounts in