topic Re: Empty value first in QlikView

Empty value first

Thu, 24 Sep 2015 13:54:01 GMT

Hi,

Is there a way to sort the chart values so that the empty value would be the first value starting from the left?

Thanks in advance

giakoum — Thu, 24 Sep 2015 14:02:56 GMT

Most likely yes, if you can post a sample app that would be helpful

But I would either get rid of the null value or label it

marcus_sommer — Thu, 24 Sep 2015 14:03:44 GMT

I'm not sure what do you mean with empty values - values from days which are a sunday? Maybe something like this:

if(num(weekday(date))=6, 1, avg(date)) // as sorting-expression

- Marcus

swuehl — Thu, 24 Sep 2015 14:08:57 GMT

I assume you are talking about the rightmost bar, with no dimension value assigned.

I don't think you can show this at leftmost position unless you create a Date dimension value for these records.