Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi,
It is better if you describe your issue in detail with sample file and desired output.
Hi,
Please share a data-sample and expected result.
It will give you the result faster..
Regards,
Sergey
Please Find the Attachment @
Test 2 Output : I want it like this
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
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..