Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

I am having trouble in using Filtered Views in the QlikView Dashboard. When i use the Filtered views and run locally dashboard works fine. But, problem occurs when i publish to the QMC & it won't retrieve any results from the view . This problem doesn't occur when i use tables instead of Filtered Views

For eg.,  Using following table works fine

LOAD id,

name

SQL SELECT *

FROM Contact (NOLOCK);

 But if i use the following Filtered View, the view doesn't execute & won't retrieve any results after publishing to QMC.

LOAD id,

name

SQL SELECT  *

FROM FilteredContact (NOLOCK);

Does anyone has a fix to this or any suggestions on how to handle this ?

 

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

My guess is that the userid running the reload in QMC does not have access to the view?

-Rob

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

My guess is that the userid running the reload in QMC does not have access to the view?

-Rob

View solution in original post

Highlighted
Contributor
Contributor

Re: Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

Rob, 

Thanks for the reply ! Do you know how to check about the access ? Is that something that needs to be done on QMC ? or Server ? 

MVP & Luminary
MVP & Luminary

Re: Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

The security access would be defined in the Dynamics server