topic Re: Is this possible? in QlikView

Is this possible?

Mon, 20 Oct 2014 20:17:02 GMT

I have created the following pivot table with tracks rev & exp compared to budget. See below:

The expression for pulling the information is:

for Revenue: =sum({$<Type = {'Revenue'},TC={12},CalYear={2014}>}[Transaction Amount])

for Expenses: =sum({$<Type = {'Expenses'},TC={11},CalYear={2014}>}[Transaction Amount])

Is it possible it have both the Revenue and Expenses in the same expression?

Below is what I need this to file to look like:

(I have to export this to excel in order to pull revenue and expenses into a single column)

JonnyPoole — Mon, 20 Oct 2014 20:26:35 GMT

You can try change an expressions to conditionally display revenue or expense using something like this....

if( Type='Revenue',

sum({$<Type = {'Revenue'},TC={12},CalYear={2014}>}[Transaction Amount]),

if( Type='Expenses', sum({$<Type = {'Expenses'},TC={11},CalYear={2014}>}[Transaction Amount]) )

)

Mon, 20 Oct 2014 20:35:54 GMT

Thank you very much!