Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
pkpandey
Contributor III
Contributor III

direct discovery

I have a dimension BUYER_K, and measure Totalkgs_DD in direct discovery and it is joined with the in memory key BUYER_K. While calculating the BUYER_K wise Totalkgs_DD, it is showing correct value but while calculating value SALE_NO_DD wise, it is showing wrong value. What might be the problem. My direct discovery script and data model screen shots are as follows.

directdiscovery:

DIRECT QUERY

dimension

  Broker As Broker_DD,

  Centre As Centre_DD,

  "Sale No" As SALE_NO_DD,

  Buyer As BUYER_K,

  Season As SEASON_DD

measure

  Totalkgs As Totalkgs_DD,

  Totalkgs*AuctionPrice As VALUE_DD

from eAUCTION.dbo."OTB_12_13";

Please help, this is very urgent.

Labels (1)
0 Replies