Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

james_hanify
New Contributor III

Document loading severely reduced after changing a pivot table

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

Community Browser