topic What chart do i need to create this layout? in QlikView

What chart do i need to create this layout?

amien — Wed, 29 Jun 2011 11:06:28 GMT

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?

What chart do i need to create this layout?

swuehl — Wed, 29 Jun 2011 12:43:36 GMT

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

What chart do i need to create this layout?

Wed, 29 Jun 2011 20:22:30 GMT

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

What chart do i need to create this layout?

amien — Thu, 30 Jun 2011 06:31:55 GMT

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

Thanks