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
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.

Community Browser