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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
vintac
Partner - Contributor III
Partner - Contributor III

Wrong rows count extracted with tSAPTableInput from SAP CDS view

Hello,

i'm trying to extract a CDS view from SAP S4 Hana using tSAPTableInput, but the count of rows extracted is wrong and much bigger.
I know that my CDS view has 3,6M of rows, but the component, before i stopped the execution, was already at 8,3M rows extracted, and i can't understand why. 
Does anyone have an idea about what's wrong? 
Thanks in advance for help,

Vincenzo.

vintac_0-1762336417675.png

vintac_1-1762336433516.png

vintac_2-1762336467516.png

vintac_3-1762336551875.png

 

 

 

Labels (2)
4 Replies
1994
Contributor
Contributor

in qlik sense can we add total as row in pivot table any position in table

 

 

vintac
Partner - Contributor III
Partner - Contributor III
Author

Sorry, i don't understand what you mean, could you explain better?

1994
Contributor
Contributor

In a Qlik Sense pivot table, there is a dimension called Account Name. For example, there are six account names — three with positive values and three with negative values. I want to add a total row that shows the sum of only the three positive account values after that 3 account name

1994_0-1762339441302.png

 

vintac
Partner - Contributor III
Partner - Contributor III
Author

Sorry, but how is this related to my question?