Having an expression return two values?

Thu, 07 May 2015 14:10:07 GMT

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

Re: Having an expression return two values?

Gysbert_Wassenaar — Thu, 07 May 2015 14:17:31 GMT

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

topic Having an expression return two values? in QlikView

Having an expression return two values?

Re: Having an expression return two values?