Pivot table format

priyarane — Thu, 14 May 2015 09:47:08 GMT

Hi Experts,

Please check my screen shots.

screen1 - Right now my dashboard looks like that.

screen2 - requirement which I need to create.

like: Parent - Child-subchild

EAD

Risk Weighted Assets (Current)

Capital (Current)

Total RWA including Notionals (Current)

EAD (Current)

Credit

Market

Ops

Total

Deductions

Expected Loss

ALLL

Expected Loss - ALLL

Total Capital

Capital Deductions Notional

EL-ALLL Shortfall Notional

Intangible Assets Notional

CRD IV Notional

Total RWA plus Notionals

CCR

NCCR

Headings(EAD,Risk Weighted Assets (Current),Capital (Current).......),subchild(CCR,NCCR) are not in my data.. so how to do it. Can some one please help me.

Re: Pivot table format

john_s_w_wood — Thu, 14 May 2015 10:39:47 GMT

I may need to see your example qvw but it looks like you need to have the dimension with the CCR, NCCR content in and drag it to the horizontal position (Click on the field name and drag with the mouse. It will show either a blue vertical or horizontal line to indicate whether the field will be in rows or columns)

topic Pivot table format in QlikView

Pivot table format

Re: Pivot table format