topic Re: DD & section access problem in QlikView

DD & section access problem

Thu, 03 Jul 2014 06:17:48 GMT

I use DD and section access. I find one problem .

the DD script:

DIRECT QUERY

dimension

KEY_IOD

// key_gof,

// key_stock

measure

ActualQty

detach

SizeName

// NATIVE('cast(SizeName as varchar(20))') as SizeName

detail

UpdateDate

FROM TestData.dbo."Inv_Material";

My section access is related to KEY_IOD and no relation with SizeName.

I open the file in IE client like accesspont . It is ok.

I open directly in computer . The SizeName disappear as the pic1. If I reload it ,it is ok .

I know the section access cause this problem . How to solve it ?

Thu, 03 Jul 2014 06:36:03 GMT

pic2 is the right result on accesspoint . After reload ,the result is the same as pic2.

Fri, 30 Oct 2015 11:32:46 GMT

Did you manage to solve this issue?

Anonymous — Thu, 12 Nov 2015 15:42:02 GMT

DD works with SectionAccess on AccessPoint only. You have to develope without SectionAccess and test with SectionAccess on AccessPoint.

Direct Discovery Technical Addendum_11.2_SR11_and_Sense.pdf

3.7 Unsupported QlikView and Qlik Sense Functionality

Set Analysis

More than one calculated dimension in a direct discovery chart

Direct Discovery Measure and Detail fields are not supported on Global Search

Client side section access and data reduction

Loop and Reduce

Synthetic keys on the direct discovery table