Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Problem with bar+line chart and percentages

I'm trying to show a chart with bars showing number of tasks per month, and line showing percentage between completed and in progress tasks. But I can't figure out the correct settings for the line, so it shows up like this:

qv-percentage-line.png

Does anyone know what settings I need to change in order to get the line to show properly?

// Mika

Tags (1)
1 Solution

Accepted Solutions
dennisnet
Valued Contributor III

Problem with bar+line chart and percentages

Hi There,

Try to change the order of your dimensions.

So promote your StartMonth to your first dimension.

That should solve your problem.

Good Luck,

Dennis.

3 Replies
Highlighted
chauhans85
Esteemed Contributor

Problem with bar+line chart and percentages

check expression for line

chart ->properties-> number-> fixed to 2

and at all expression -> value on data point.

or else share the sample file

Not applicable

Re: Problem with bar+line chart and percentages

Here's a sample file, it looks a bit different as I stripped out meaningless data. I'm thinking that the percentage line is drawn for the year dimension, not the month dimension, but not really sure.

Month names are in finnish.

task-report-image.png

dennisnet
Valued Contributor III

Problem with bar+line chart and percentages

Hi There,

Try to change the order of your dimensions.

So promote your StartMonth to your first dimension.

That should solve your problem.

Good Luck,

Dennis.