MERGE IN PIVOT TABLE

[#1]

i HAVE achieved  PIVOT TABLE OUTPUT LIKE THIS

Database_Link

Phase_Link

Number Of Machine

Rating (in MW)

Generation Budget For the Day

Generation Actual For the Day

PLF BP For the Day

PLF Actual For the Day

Budget MA% For the Day

MA ACTUAL% For The Day

Generation BP MTD

Generation Actual MTD

PLF BP MTD

PLF MTD

MA  BP MTD

MA MTD

Generation BP YTD

GENERATION YTD

PLF BP YTD

PLF YTD

MA  BP YTD

MA YTD

Database _Link AND phase_Link is Dimension rest of them is expression.

And further i have to represent it like this

For The Day

For the Month

For the year

Budget

Actual

Budget

Actual

Budget

Actual

Database_Link

Phase_Link

Number Of Machine

Rating (in MW)

Generation

PLF

MA%

Generation

PLF

MA%

Generation

PLF

MA%

Generation

PLF

MA%

Generation

PLF

MA%

Generation

PLF

MA%

Please suggest if its possible in Qlikview and if it is how can we achieve it ?

[#2]

Hi,

It is better if you describe your issue in detail with sample file and desired output.

[SergeyMak]

Hi,

Please share a data-sample and expected result.

It will give you the result faster..

Regards,

Sergey

[#4]

Please Find the Attachment @

Test 1 output : i have achieved this

Test 2 Output : I want it like this

[#5]

For you to have that desired Pivot Columns, you should create it as a field in Qv.

it will be a great help for us to check your problem if you can send us your Qv File.

regards,

Charles

[SergeyMak]

You have two datatypes:

First - Time (Month, Day, For The Year)

Second - Actual and Budget

So you need two additional columns:

TimeType and DataType

For Every Actual field in Load script you have to add "Actual" and Budget - Budget

etc.

Then you can use these fields to create a Pivot Table

Another case you can add two fake columns to your chart, and drive your expressions depending on the value

ValueList('Day','Month','Year')

ValueList('Actual','Budget')

but I think it's just more complex..