Direct Discovery

nitin_01 — Wed, 03 May 2017 06:58:27 GMT

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

Would appreciate n thankful for the help gwassenaar‌ hic‌ stalwar1‌ tresesco‌ petter-s‌ jagan‌ rwunderlich‌

topic Direct Discovery in QlikView

Direct Discovery