Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

DD & section access problem

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  ?

Tags (2)
3 Replies
Not applicable

Re: DD & section access problem

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

Not applicable

Re: DD & section access problem

Did you manage to solve this issue?

dimitri_obrant
Contributor

Re: DD & section access problem

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

Community Browser