topic Re: Curves graphism problem in QlikView

Curves graphism problem

Mon, 22 Jun 2015 08:48:54 GMT

Hello everybody,

I have a litle problem with curves graph

I have 3 expression into this curves.

Problem : i get 3 separate Y values, i want to have for example at x= 2015 the "critèere Z" curve near "critère T" because there is juste "1" betwenn them (28 - 27 =1 )

Hope you understand what i'm tryng to do, i'lll join a sample qvw.

Thanks

Re: Curves graphism problem

fvelascog72 — Mon, 22 Jun 2015 08:54:03 GMT

Hi,

I think you could change Look style in Style Tab to solve tyour issue.

Regards

Re: Curves graphism problem

Mon, 22 Jun 2015 09:01:35 GMT

OK, im trying to, but dont see where to do that, can you make it with the qvw file joined?

Re: Curves graphism problem

fvelascog72 — Mon, 22 Jun 2015 09:07:38 GMT

Hi,

The first option will show the real values.

Re: Curves graphism problem

Mon, 22 Jun 2015 09:10:35 GMT

thanks for the helps,

but in fact i dont want to change curves style, but to get this result with my current style, u understant more now?

Thanks

Re: Curves graphism problem

r_wroblewski — Mon, 22 Jun 2015 09:29:17 GMT

Please check attached modified qvw.

Please be aware that for 2013 the values not correct because Z value is less than X value.

Maybe you can use an if-statement to fix the issue. For details see the expression tab.

I hope this will help you to achieve what you want.

Regards,

Ronny

Re: Curves graphism problem

Mon, 22 Jun 2015 09:59:54 GMT

Thanks a lot Ronny,

your solution is excellent, now i try to do with my real qvw, what i have to do to have all the Y values down?

Can you explain step by step, what you did and why, so i can understand deeply.

Thanks

Re: Curves graphism problem

r_wroblewski — Mon, 22 Jun 2015 10:15:01 GMT

Hi,

just look inside the chart properties to see all changes.

I used one value as base (X) and than calculate the differences.

Line Z is Sum(Z-X) & Line T is Sum(T-Z-X). As long as there is a positive difference it is working fine but for 2013 you have a negative difference between X and Z which return wrong results for Z & T, compared to your data.

The problem is now how this case should be displayed !

I think an if statement could solve this. I will check later if I can find a proper solution.

Regards,

Ronny