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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-01-04 12:41 PM

error aggr on pivot table

<body><p>Dear all</p> <p>I have an error on a pivot table and i dont know how to solve it. </p> <p> </p> <p>I have 3 Dimensions an one of them is a calculated one. </p> <p>I have to expressions. </p> <p> </p> <p>A sum and another one to calculate percentaje. </p> <p> </p> <p>Problem is that aggr function only give me the correct data on one column and not in all. </p> <p> </p> <p>Here is data obtained, but I need all the aggr be 736 on D1-1 D2-1 and not null , and 636 on D1-1 D2-2 to do Numericcount/aggr to get percentaje</p> <p><a href="https://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1638.Esquema.JPG"><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/1638.Esquema.JPG" border="0" /></a></p> <p> </p> <p> </p> <p> </p> <p> </p> <p><col width="98"></col> <col width="98"></col> <col width="98"></col> <col width="493"></col> <col width="229"></col> <tr height="17"> <td height="17" class="xl24" width="98"><br /></td> <td class="xl24" width="98"><br /></td> <td class="xl25" width="98"><br /></td> <td class="xl22" width="493"></td> <td class="xl22" width="229"><br /></td> </tr> </p> <p> </p> <p> </p> <p> </p> <p> </p></body>

832 Views
0 Likes
1 Solution

Accepted Solutions
Not applicable
‎2011-01-04 01:12 PM
Author

SOLVED AGGR(NODISTINCT......

View solution in original post

235 Views
0 Likes
1 Reply
Not applicable
‎2011-01-04 01:12 PM
Author

SOLVED AGGR(NODISTINCT......

236 Views
0 Likes