Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to make a dump of one of my tables.
In the example I've added part of the table (the table I'm working with contains more columns).
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.
Chart A will give me the correct result.
However as all of the other records are added as dimensions I can't get the layout of this chart right.
I would like to add a scrollbar underneath the dimensions.
Is this possible?
Alternatively I could add many dimension as an expression (as done in Chart B or in table 1)
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).
Can anyone help me out with the conditional statement?
See attached qvw
Thanks for helping me out twice, today!
I still have a lot to learn - so if you encounter another one of my questions the help will be very much appreciated.