Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Add conditional statement (or extend the scroll-bar)

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?

1 Solution

Accepted Solutions

Re: Add conditional statement (or extend the scroll-bar)

See attached qvw


talk is cheap, supply exceeds demand
2 Replies

Re: Add conditional statement (or extend the scroll-bar)

See attached qvw


talk is cheap, supply exceeds demand
Not applicable

Re: Add conditional statement (or extend the scroll-bar)

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.

Community Browser