topic Add conditional statement (or extend the scroll-bar) in QlikView https://community.qlik.com/t5/QlikView/Add-conditional-statement-or-extend-the-scroll-bar/m-p/506898#M553683 <HTML><HEAD></HEAD><BODY><P>I'm trying to make a dump of one of my tables.</P><P>In the example I've added part of the table (the table I'm working with contains more columns).</P><P>The conditional I'm looking for is that any of 4 fields (actual hours, actual volumes, forecasted hours or forecasted volumes) should contain a value bigger than 0.</P><P></P><P>Chart A will give me the correct result.</P><P>However as all of the other records are added as dimensions I can't get the layout of this chart right.</P><P>I would like to add a scrollbar underneath the dimensions.</P><P>Is this possible?</P><P></P><P>Alternatively I could add many dimension as an expression (as done in Chart B or in table 1)</P><P>This will improve the layout - but I can't figure out what conditional statement must be added to leave out the extra record (containing only 0-values for the 4 fields (actual hours, actual volumes, forecasted hours or forecasted volumes).</P><P>Can anyone help me out with the conditional statement?</P></BODY></HTML> Wed, 11 Sep 2013 07:33:57 GMT 2013-09-11T07:33:57Z Add conditional statement (or extend the scroll-bar) https://community.qlik.com/t5/QlikView/Add-conditional-statement-or-extend-the-scroll-bar/m-p/506898#M553683 <HTML><HEAD></HEAD><BODY><P>I'm trying to make a dump of one of my tables.</P><P>In the example I've added part of the table (the table I'm working with contains more columns).</P><P>The conditional I'm looking for is that any of 4 fields (actual hours, actual volumes, forecasted hours or forecasted volumes) should contain a value bigger than 0.</P><P></P><P>Chart A will give me the correct result.</P><P>However as all of the other records are added as dimensions I can't get the layout of this chart right.</P><P>I would like to add a scrollbar underneath the dimensions.</P><P>Is this possible?</P><P></P><P>Alternatively I could add many dimension as an expression (as done in Chart B or in table 1)</P><P>This will improve the layout - but I can't figure out what conditional statement must be added to leave out the extra record (containing only 0-values for the 4 fields (actual hours, actual volumes, forecasted hours or forecasted volumes).</P><P>Can anyone help me out with the conditional statement?</P></BODY></HTML> Wed, 11 Sep 2013 07:33:57 GMT https://community.qlik.com/t5/QlikView/Add-conditional-statement-or-extend-the-scroll-bar/m-p/506898#M553683 2013-09-11T07:33:57Z Re: Add conditional statement (or extend the scroll-bar) https://community.qlik.com/t5/QlikView/Add-conditional-statement-or-extend-the-scroll-bar/m-p/506899#M553684 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Wed, 11 Sep 2013 11:07:07 GMT https://community.qlik.com/t5/QlikView/Add-conditional-statement-or-extend-the-scroll-bar/m-p/506899#M553684 Gysbert_Wassenaar 2013-09-11T11:07:07Z Re: Add conditional statement (or extend the scroll-bar) https://community.qlik.com/t5/QlikView/Add-conditional-statement-or-extend-the-scroll-bar/m-p/506900#M553685 <HTML><HEAD></HEAD><BODY><P>Thanks for helping me out twice, today!</P><P>I still have a lot to learn - so if you encounter another one of my questions the help will be very much appreciated. </P></BODY></HTML> Wed, 11 Sep 2013 16:08:01 GMT https://community.qlik.com/t5/QlikView/Add-conditional-statement-or-extend-the-scroll-bar/m-p/506900#M553685 2013-09-11T16:08:01Z