Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Key figures in a pivot/straight table

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

YearMonthVersion (0 for planned, 1 for actual)Sales
01/2013

0

300
01/20131250
01/20131150
02/20130350
02/20131250

....

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

YearMonthActual (version=1)Planned (version=2)
01/2013400300
02/2013250350

....

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!

2 Replies
MK_QSL
MVP
MVP

Please check enclosed file..

MK_QSL
MVP
MVP

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

];