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

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