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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Having an expression return two values?

Hello,

I am in the process of trying to figure out how to format my pivot table so that it looks similar to the excel table. Below is a screen shot of excel table.

I was wondering if it is possible to have an expression return two values in a pivot table? Basically like a statistics box that that has a field being Date and also the Outstanding (1 - 30 days) field.

Any ideas or help would be greatly appreciated!

Thanks,

Michele

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Simply use two expressions and drag the expressions to the left to pivot them to vertical layout.

The alternative is an expression like: =sum(Value) & chr(10) & money(count(Value))


talk is cheap, supply exceeds demand