Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Graphic histogram and sales margins

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

1 Solution

Accepted Solutions
Partner
Partner

something like that

View solution in original post

8 Replies
Partner
Partner

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

Partner
Partner

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

Not applicable

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

Thanks

G P

Partner
Partner

something like that

View solution in original post

Not applicable

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

Partner
Partner

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

Sum( [Sales Value]) should do it

Not applicable

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

Partner
Partner

yes that is why we create the small multiples