Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Multi Tenanted data

Hi All

Just wanted to get ideas for QlikSense/QlikView on multi tenancy for data.

Scenario is this ...

              Company XYZ and its sales data

              Company ABC and its sales data

              ... and so on

QlikSense App to provide data visualizations to all companies, but of course we want to allow

Company XYZ their data visualizations only , Company ABC their data visualizations only and so on.

The question I have is what is the best approach in the Qlik architecture for this ?

Has anyone done this in their Enterprise solutions at all ?

Thanks

Paul

4 Replies
Highlighted

Re: Multi Tenanted data

It seems like you are looking for a loop and reduce functionality which is available in QMC. For more information look here:

Reduce and loop by NT username | Qlik

Loop and reduce: What does it do to section access?

Highlighted
Specialist
Specialist

Re: Multi Tenanted data

Hey Sunny , how's it going? Thanks for the links, although they are very QlikView centric, I want to

partition external company's data and present each companies to their users.

In SQLServer for example we can multi tenant via SCHEMAS and associate accounts (e.g. multiple companies) such that Co. ABC sees only their data and Co. XYZ sees their own data.

I guess I an hoping someone out there has done this using QlikSense security etc. This is early days into my

research.

thanks

Paul

Highlighted

Re: Multi Tenanted data

Hey Paul,

I am doing good. What about you?

I don't have much experience with Qlik Sense and not sure if Loop and Reduce is yet available in Qlik Sense or not, but in Qlik View you can def. handle your requirement with Loop and Reduce.

I hope somebody from Qlik Tech might be able to give you a better response.

Best,

Sunny

Highlighted
Specialist
Specialist

Re: Multi Tenanted data

Yep good, busy as

Thanks for replying, all ideas are worth exploration and discovery.

I have a feeling I'm treading in new and untried territory with my requirements.

cheers

Paul