
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to Limit Data for each Sheet in QlikSense
HI Team,
I am loading ~1 million records into Qlik App. These Records are related to different Org codes.
Now I need to Create separate sheets (one sheet for each Org code) for each Org code with a Stright Table. How can we implement this in a simple way in QlikSense?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check this (Apps on demand)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the Suggestion @OmarBenSalem
As per my understanding, On Demand App Generation will be helpful for Adhoc Reports , where users can make selections & Report will be generated based on Selections.
But here my requirement is much Simple, We just need 3-4 sheets , where each sheet will have data related to one Org code. I think there should be a simple solution for this.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi!
Just to be clear, should people from on department be restricted from seeing data belonging to other departments? Or is the request, as you say, just to create sheets with data for different Org codes?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@jbhappysocks , No We are not worried about that now. Each org will have different types of products. So we just need to have them in a Separate sheet.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ok, then the easiest way to do it is just to include {<"Org Code" = {'XXX'}>} in the measure on every sheet
So if your Org Codes are Dep1 and Dep2 and your looking at Sum(Sales) it should be
Sum({<"Org Code" = {'Dep1'}>} Sales)
Sum({<"Org Code" = {'Dep2'}>} Sales)
on their respective sheets.
You also might want to exclude zerovalues (check box under Add-ons/Data Handling)
