What chart do i need to create this layout?

[amien]

see screenshot attached.

i also need the headers : customer, costs, financial.

I don't think i can create this using a pivot. Do i need to create labels or something in my loading script?

[swuehl]

Hi,

well, I don't think that QlikView logic offers an easy way, because I don't see how to get your results types (column 1) into a dimension easily. And then you have pretty different calculations as expressions.

For sure you can build this kind of results overview e.g. with an array of text boxes (some fixed, some calculated expressions) or separate tables.

But maybe some of the Gurus in this forum has a much better idea..

Regards,

Stefan

[#3 · Accepted solution]

Hi Amien.

I usually create a list with concepts  for mi dimension.

You can use LOAD IN LINE or an Excel file.

Concept               Order

Customer                1

# of Orders              2

Profit                        3

Cost                         4

Employee                5

Training                   6

Then, with a straight table, your dimension is "Concept"

And you need to create every field for each concept, i use this "Pick()"

Expresion 1:

pick(Order,

//1 Customer

''

,//2 # Orders

sum(NumOrders)

,// 3 Profit

sum(Profit)

,// 4 Cost

''

,//5 Employee

sum(Emp_Cost)

...

)

Of course you need to add a Set Analisys or IF in SUM() to get This Year or Last Year Info.

Hope this help you.

Try it, if you need an example let me know to upload a qvw.

Regards

[amien]

Great .. bit stupid .. i remember now that i'v used this function before, but didnt came up with this solution

Thanks