topic Re: Build a chart based on different columns in QlikView

Build a chart based on different columns

Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone,

I want to built this chart, The row level values will be changed as per the headers - TOTAL , ALM , TRADING & SCG , SALES , INVESTMENTS , INTL & OTHERS

Can anyone suggest how to build this ?

Re: Build a chart based on different columns

alexandros17 — Mon, 08 Aug 2016 12:55:39 GMT

You need a pivot table, to group columns by label you need a dimension that contains the values

TOTAL , ALM , TRADING & SCG , SALES , INVESTMENTS , INTL & OTHERS

(you can do this with a load inline)

Then you must link the fields used in the columns to the field containing labels.

Let mew know

Re: Build a chart based on different columns

Mon, 08 Aug 2016 13:32:07 GMT

Thanks for the response.

The row level fields NII,NFI,INVEST/CDS will be having different calculation for different headers-

For example - NII FOR ALM - NII will be based on a segment known as ALM

NII FOR TRADING & SCG - NII will be based on a segment known as Trading & SCG

How can i differentiate the values according to the Segment in one expression

Re: Build a chart based on different columns

vinieme12 — Mon, 08 Aug 2016 14:05:16 GMT

can you provide a sample to demonstrate?

Re: Build a chart based on different columns

Mon, 08 Aug 2016 15:22:48 GMT

Here values under TOTAL header for NII is calculated for total when Segment = TOTAL and INDICATOR = ACT

and for ALM header NII will be calculated when Segment = ALM and INDICATOR = BUD

How can i bring these 2 calculation under one expression for NII ?

Re: Build a chart based on different columns

vinieme12 — Mon, 08 Aug 2016 19:37:52 GMT

can you provide sample data so people here can help you better

Preparing examples for Upload - Reduction and Data Scrambling