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: 
Not applicable

Pivoting both expended and collapsed

Hi. I want to pivoting issued and paid amount for month. I created pivot table like this. for example

paid_amount issue_amount
paid_dateDec 2011Jan 2012Feb 2012Mar 2012Apr 2012May 2012Jun 2012Aug 2012-Dec 2011Jan 2012Feb 2012Mar 2012Apr 2012May 2012Jun 2012Aug 2012-
issue_date40,878.0040,909.0040,940.0040,969.0041,000.0041,030.0041,061.0041,122.00 40,878.0040,909.0040,940.0040,969.0041,000.0041,030.0041,061.0041,122.00
Jan 2012400.00224,760.00116,440.003,755.001,010.002,520.00200.00180.000.004002247601164403755101025202001802155

for paid amount it is ok. It show amount for each month. But for issued_amount I do not want to see devided by month. just want to see total. How can I do this?

0 Replies