0 Replies Latest reply: Nov 11, 2017 11:46 AM by James Hanify RSS

    Document loading severely reduced after changing a pivot table

    James Hanify



      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