topic Re: Model might be correct - However missing data in QlikView

Model might be correct - However missing data

derekledbetter — Tue, 19 Sep 2017 12:41:48 GMT

Good Morning,

The Idea is to have "DisplayNM" with SSRSData. The chart is using MAX(SSRSTimeEnd) and that is working. However, the chart doesn't always show the "user" for that row.

I realize I'm still a newbie and while the model may be incorrect, the idea is to have AuditData,SessionData, and ConcurrentSession (used). Then, the SSRS Data is (report side) and will be in another chart at the bottom with : Last Time Ran, Last User, and Count(SSRSRowNumber) - number of times report is ran.

both Model and result is posted below.

I appreciate the response in advance.

Thanks,

Derek

Re: Model might be correct - However missing data

avinashelite — Tue, 19 Sep 2017 13:17:17 GMT

I feel their is 1 to many relation with the data your trying to pull in the chart and its not able to validate which data it need to pull ..share the app , will check and let you

Re: Model might be correct - However missing data

derekledbetter — Tue, 19 Sep 2017 13:34:26 GMT

Thank you very much.

I wrote a CTE (again not knowing I could) and have let SQL do the heavy lifting.

Re: Model might be correct - However missing data

avinashelite — Wed, 20 Sep 2017 05:37:46 GMT

Could you share the sample app ??