topic Re: Key figures in a pivot/straight table in QlikView

Key figures in a pivot/straight table

Thu, 06 Feb 2014 14:17:05 GMT

I need help in the app design/development. I have data coming on a straight table format like this:

YearMonth	Version (0 for planned, 1 for actual)	Sales
01/2013	0	300
01/2013	1	250
01/2013	1	150
02/2013	0	350
02/2013	1	250

....

I would need to show the data in a following matter:

YearMonth	Actual (version=1)	Planned (version=2)
01/2013	400	300
02/2013	250	350

....

This is a simplified example, there are as many as 5-6 dimensions such as "Version" affecting which rows to pick into the report. So my question is, is it better create the key figures inside the table/report (and how is it done?) or would you rather do it in the load script?

Thank you already in advance!

Re: Key figures in a pivot/straight table

MK_QSL — Thu, 06 Feb 2014 15:00:16 GMT

Please check enclosed file..

Re: Key figures in a pivot/straight table

MK_QSL — Thu, 06 Feb 2014 15:04:34 GMT

You can create an Inline Table in load script...

Load * Inline

[

VersionID, Version

0, Planned

1, Actual

2, Good

3, Enough

4, Far

];

Load *

Inline

[

YearMonth, VersionID, Sales

01/2013, 0, 300

01/2013, 1, 250

01/2013, 2, 100

01/2013, 3, 150

01/2013, 4, 300

01/2013, 1, 150

02/2013, 0, 350

02/2013, 1, 250

03/2013, 4, 400

03/2013, 3, 250

03/2013, 1, 350

];