topic Re: Waterfall: Negative Values shown as '0' and wrong in QlikView https://community.qlik.com/t5/QlikView/Waterfall-Negative-Values-shown-as-0-and-wrong/m-p/1225136#M518111 <HTML><HEAD></HEAD><BODY><P>Check the Attachment</P></BODY></HTML> Thu, 24 Nov 2016 19:21:35 GMT settu_periasamy 2016-11-24T19:21:35Z Waterfall: Negative Values shown as '0' and wrong https://community.qlik.com/t5/QlikView/Waterfall-Negative-Values-shown-as-0-and-wrong/m-p/1225135#M518110 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm facing a somehow strange error in QlikView:</P><P></P><P>I'd like to show a Waterfall chart from one year to the next, displaying the countries which are "growth accretive" or "dilutive"...</P><P><SPAN style="font-size: 10pt;">Somehow, it works with 3 charts... haha - I think I don't need to figure out which problems I will have with that workaround.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">The best thing would be, to have all bars combined in one chart... Well, somehow I managed to do so with the "Pick" Function using several dimensionalities in the chart (See screenshot, second chart)</SPAN></P><P><SPAN style="font-size: 10pt;">It comes to an more or less good picture, except the negativ figures on the growth: They are drawed in the wrong direction and the number shows "0" and not a negative figure. On the axis, the right value is shown somehow.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I don't need to use the "pick" function as a solution, maybe one of you has better ideas to draw this in one chart?</SPAN></P><P><SPAN style="font-size: 10pt;">Maybe you also know how to edit the existing chart to come to the desired chart?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Also, I'd like to keep the flexibilty to have more or less countries between these two FiscalYear-bars:I don't want to have an expression for each and evry country in the middle... that's why I went this way until now...</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I also added the .qvw to let you have an insight how I implemented everything.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Many thanks for your help!</SPAN></P><P><SPAN style="font-size: 10pt;">BR</SPAN></P><P><SPAN style="font-size: 10pt;">Stefan<BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P></BODY></HTML> Thu, 24 Nov 2016 16:18:47 GMT https://community.qlik.com/t5/QlikView/Waterfall-Negative-Values-shown-as-0-and-wrong/m-p/1225135#M518110 stefangegg 2016-11-24T16:18:47Z Re: Waterfall: Negative Values shown as '0' and wrong https://community.qlik.com/t5/QlikView/Waterfall-Negative-Values-shown-as-0-and-wrong/m-p/1225136#M518111 <HTML><HEAD></HEAD><BODY><P>Check the Attachment</P></BODY></HTML> Thu, 24 Nov 2016 19:21:35 GMT https://community.qlik.com/t5/QlikView/Waterfall-Negative-Values-shown-as-0-and-wrong/m-p/1225136#M518111 settu_periasamy 2016-11-24T19:21:35Z Re: Waterfall: Negative Values shown as '0' and wrong https://community.qlik.com/t5/QlikView/Waterfall-Negative-Values-shown-as-0-and-wrong/m-p/1225137#M518112 <HTML><HEAD></HEAD><BODY><P>Thank you so much, Settu! Never thaught the solution would be that simple and I was so close to the goal <SPAN style="font-size: 10pt;"><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></P><P></P><P>Alll in all, I'm so happy to have this community here - everybody helps that fast and the community works so good (in terms of give and take!)</P><P></P><P>BR</P><P>Stefan</P></BODY></HTML> Fri, 25 Nov 2016 07:07:59 GMT https://community.qlik.com/t5/QlikView/Waterfall-Negative-Values-shown-as-0-and-wrong/m-p/1225137#M518112 stefangegg 2016-11-25T07:07:59Z Re: Waterfall: Negative Values shown as '0' and wrong https://community.qlik.com/t5/QlikView/Waterfall-Negative-Values-shown-as-0-and-wrong/m-p/1225138#M518113 <HTML><HEAD></HEAD><BODY><P>No problem at all <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 25 Nov 2016 15:23:12 GMT https://community.qlik.com/t5/QlikView/Waterfall-Negative-Values-shown-as-0-and-wrong/m-p/1225138#M518113 settu_periasamy 2016-11-25T15:23:12Z