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