Document loading severely reduced after changing a pivot table

james_hanify — Sat, 11 Nov 2017 16:46:11 GMT

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

topic Document loading severely reduced after changing a pivot table in App Development

Document loading severely reduced after changing a pivot table