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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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