Sending a Query to Database to get subset of data from Qlikview

[chiru_thota]

Hi All,

We are working to provide a solution for one of our Business Requirement.

Requirement:

**********************************************************************************************************************************************************

We have big table with so much of data and it grows drastically day by day  and we don't want to load all the data into QVW.

But when a user log in to Qlikview Application he has to get only rows which has his user ID in database table rows.

User ID	Dim1	Dim2	Dim3	Metric1	Metric2	Metric3	………So on

*******************************************************************************************************************************************************

Is there any solution for above requirement?

I have explored Direct Discovery and it may not helpful with above requirement.

Thanks in Advance,

Chiru.

[MayilVahanan]

Hi

I think you are expecting like section access. based on authentication, he can see his data alone.

Check with section access concept.

[chiru_thota]

Hi Mayil,

Thanks for reply.I am not looking for section access actually.

I don't want to load all the users data in to QVW file as my file size is increasing like anything (more than 1 GB).

I want to fetch the data from table only for the user who logged in.

select * from table where User ID = User1;  (User1 is the person who is accessing application at that point of time)

Thanks,

Chiru

[Anonymous]

Hi Chiru,

I agree with Mayil Vahanan Ramasamy - it can be done using section access with the data reduction.

An alternative - use reload with reduction, creating one QVW file per user.

Regards,

Michael