Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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

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