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

      Hi,

       

      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)

       

      Account

      AccountKey

      Flag (1 or 0, did have it set to Y but changed it)

       

      Invoice

      AccountKey

       

      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