Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loop and Reduce Question

I have a dashboard that has different information about branches. We assign 10 branches access to test initially and we us NT names to qualify the branches in the security group. Each branch is only allowed to see their branch information and no other branch's information, except where showing company overall info.

The main dashboard for executive access works well and are able to see all the information available for any branch selected. When the the individual branches access their dashboard, the logic in the loop and reduce seems to not be working correctly as the numbers arent showing up correctly. For example when user/branch AB logs in, they overall council number should be 8 but then after the loop and reduce it is 4 which is in correct.

Problem is that when any one of the 10 NT access branches login in, they dont get the right information. Seems like the loop and reduce is affecting more than the fields it should be affecting.  On my laptop/desktop version all is working correctly but once loop and reduced on the test server then some numbers are inaccurate.  Any idea?

2 Replies
Not applicable
Author

I am not sure how you implemented the data model. If you can share your data model or application we can understand it better.

But the numbers arent reliable when there is a loop.

Regards,

Kiran Rokkam.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

When you say "overall council number" do you mean a total for all branches? Loop and reduce will remove rows, so the overall total will no longer be available.

-Rob