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.
nitin_01
Contributor

Direct Discovery

Hi fellas,

      I am working on direct discovery from last couple of days, well I have used every conventions that are supposed to be used for implementing direct discovery, I am getting dimensions i.e. in-memory and I can see measures while creating chart but still facing some issues while rendering chart that I am mentioning below with attached image.

Below is the script.

Direct_Discovery:

DIRECT QUERY

dimension

     "CAR_SALES_ID",

     "CAR_SALES_CAR_INVENTORY_MASTER_ID",

     "CAR_SALES_CAR_MODEL_ID"   

measure  

     "CAR_SALES_RETAIL_PRICE", 

     "CAR_SALES_SELLING_PRICE",

     "CAR_SALES_ENTRY_DATE",

     "CAR_SALES_MODIFY_DATE",

     "CAR_SALES_DISCOUNT",

     "CAR_SALES_DISCOUNT_PERCENT"

  

FROM "CAR_INVENTORY_STORE".dbo."CAR_SALES_MASTER";

And this is what I am getting at front end in below image while using measure in chart as well as table box

direct discovery.PNG

Would appreciate n thankful for the help gwassenaarhicstalwar1tresescopetter-sjaganrwunderlich

Tags (1)
Community Browser