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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
wttaryde
Contributor III
Contributor III

Value List table Missing Data

I've built a table that uses a Value List to determine the rows.  4 of the Columns of Measures are aggregated measures (means and fractiles).  The rest are individual company results (YearID = Company Identifier).  The columns with the aggregated data fill all 3 rows of measures.  The columns with a single company data only fill the first row of measures. 

Any ideas why I'm not getting results for the rest?

wttaryde_1-1602028896226.png

 

 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

3 Replies
sunny_talwar

@wttaryde check attached

wttaryde
Contributor III
Contributor III
Author

Thank you so much. Now I know (sort of) what nodistinct is.  Perfect.

sunny_talwar

@wttaryde you can read about this issue here

AGGR() and Synthetic Dimensions