Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access limitation of 1M rows?

Section Sccess has started truncating my data set now that my app has expanded beyond 1 million rows.

The "hierarchy" of my data looks like this

Client Group

     Client

          Case

               Case Attribute A

               Case Attribute B

               ...

where Section Access is implemented on the level of the bolded underlined text above which is a 1:n relationship. A Client has many Cases but a Case belongs explicitly to a Client. Users are assigned access per Client + Case combination.

A few weeks ago the app expanded beyond 1 million Cases and that's when this issue started occurring. Here is the symptom.

> I reload the app (1,002,500 unique Cases)

> Save the qvw (still 1,002,500 unique Cases)

> Close QlikView and reopen the qvw (now exactly 1,000,000 unique Cases)

If I were to reload again without closing QlikView I would be brought back to 1,002,500 Cases.

Anyone encountered a similar issue?

QVW

10 Replies
Karthik3
Creator III
Creator III

Did you find a solution for this?