Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
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

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 ? 

Highlighted
MVP & Luminary
MVP & Luminary

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

The security access would be defined in the Dynamics server