Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Having an expression return two values?

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
Community Browser