topic Two total columns (diff, percent) horizontal as pivot / straight table layout in QlikView

Two total columns (diff, percent) horizontal as pivot / straight table layout

Fri, 15 Apr 2011 09:58:59 GMT

Hello QVer,
our users need to have a pivot / straight table with two calculated totals (difference, percent) in two columns.
According to
http://community.qlik.com/forums/t/29136.aspx
it should look like
Year 2007 2008 Diff Percent
Budget 1100 1500 +400 xx%
Sales 1000 900 -200 yy%

I constructed a table but I failed matching Diff and Percent side by side - see attached example.
Does anybody has an idea for such layout - diagram or script?
Thanks.

Two total columns (diff, percent) horizontal as pivot / straight table layout

deepakk — Fri, 15 Apr 2011 11:26:36 GMT

hi,

Check out the Attachment. i hope this helps you out.

Two total columns (diff, percent) horizontal as pivot / straight table layout

Fri, 15 Apr 2011 12:32:57 GMT

Hi,
thanks Deepak.
Would be nice but there are two challenges because there should be more than one fact data one below the other.

Can You solve it using Your suggestion?

Two total columns (diff, percent) horizontal as pivot / straight table layout

deepakk — Fri, 15 Apr 2011 12:54:22 GMT

hi,

YOu can acheive this with same example i have provided. I would like to how your identifying the Actual and Budget.

For eg : if both are coming same table. you have identify which row data is for sales and which one for budget and create a field.

If (type =..... , Sales , Budget) as Type.

eg2 : if you data is coming from two different tables...

then combine bodth the table to one..

Make sure you value field and date/year fields are same. also create a dummy field in both

'Sales' as type

'Budget' as type.

Once this is done.just add the TYpe field in dimension. YOu will get the required output.!!!