Alternate Layout for above() function?

Tue, 11 Feb 2014 13:52:34 GMT

Is there a way to restrict the output of a chart to only those values that are not null, when the above() function is being used?

Short Version:

Consider a table with MonthName as the dimension and above(count(Policies), 6) as the expression. It might look something like this:

Header 1	Header 2
Jan 2013	-
Feb 2013	-
Mar 2013	-
Apr 2013	-
May 2013	-
Jun 2013	-
Jul 2013	100
Aug 2013	110
Sep 2013	105
Oct 2013	100
Nov 2013	115
Dec 2013	120

If the display type is switched to Line Graph, there is a large blank space at the start of the graph, and I can't for the life of me seem to get rid of it.

To make matters worse, the actual dashboard I'm making uses a much more complex expression than count(Policies), so using pick(match()), while it works, is very slow (45 -75 second response rate on a large server.) Has anybody else encountered this before, or happened to build a dashboard for displaying Survival Triangles?

Thanks,

Kevin

topic Alternate Layout for above() function? in QlikView

Alternate Layout for above() function?