Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
analienx
New Contributor III

What is the base sheet/private sheet ordering logic and how to make it "non-random" while approving?

As you well know it is possible to approve community sheets to have them as base sheets. In many cases the approved sheets appear to be in "random" order. What is the logic behind and how one can actually do it it?

1 Reply
analienx
New Contributor III

Re: What is the base sheet/private sheet ordering logic and how to make it "non-random" wh

  • Sheet Rank is different for Base sheets and User´s sheets. It works the way that User´s rank is starts from 0 regardless of Base sheets - it has  its own ranking. So to be able to add the sheet as the last one you need to have your sheets rank higher than the base sheets.
    The workaround with “re-ordering the sheets before publishing” would be needed only once in the non-published app and the ordering preserves after publishing.
    If someone wanted to make changes to existing base sheet it is possible to do so but he should not change order of this sheet (if he did he would need to unapprove,unpublish and re-order the sheets )
    The best work-around is to make sheets rating < 0 before publishing an app. Easiest way to achieve so is to reorder the sheets before publishing an app and checking whether they have negative rank over DEV-HUB
  • The workaround with “re-ordering the sheets before publishing” would be needed only once in the non-published app and the ordering preserves after publishing.
  • If someone wanted to make changes to existing base sheet it is possible to do so but he should not change order of this sheet (if he did he would need to unapprove,unpublish and re-order the sheets )