Graphic histogram and sales margins

[#1]

Good morning to all,

I created an application of sales of 4 companies (Azienda).

In the first sheet "Main" I created the object histogram with the trend line of the margin.

If I select a single company (top right  "Azienda") all ok: graphic, line of margins, etc etc.

If I select all 4 companies graph marginality becomes unreadable.

Someone can help me?

Thank You.

Gian Paolo

[giakoum]

You need to create an expression for each company. Lines are not rendered as bars in QlikView. if you change it to symbol instead of line, you will visually understand why QlikView shows the line as it does

[giakoum]

Even better, create small multiples, one chart per company next to each other with same size and axis. Trellis is also an option.

[#4]

Can not please create me an example on my application that I sent you?

Thanks

G P

[giakoum · Accepted solution]

something like that

[#6]

Hi Ioannis,

good idea !!!  super

one last question: a histogram of all the companies in the stack:

first column (Jan) 4 bricks, second column (Feb) 4 bricks etc etc and then line the margin of sales overall.

I tried with formulas like:

sum ({<Company = {"D"}>} [Sales Value]) + sum ({<Company = {"I"}>} [Sales Value]) + sum ({<Company = {"P"}> } [Sales Value]) etc etc ....

or

sum ({<= {Company "D", "I", "P"}>} [Sales Value])

But it does not work ... any ideas?

Thanks again ...

Gian Paolo

[giakoum]

If you need all companies in the expression, you can omit the set analysis part.

Sum( [Sales Value]) should do it

[#8]

true ... just as it was at the beginning

Chart turnover ok with formula sum ("Sales Value")

but no margins

formula is this:

num ((sum ("Sales Value") - sum ("puchased Value")) / sum ("Sales Value"), '#. ## 0,00%')

This formula separates the company for months and the trend line is unreadable ...

thanks

G P

[giakoum]

yes that is why we create the small multiples