topic Re: Start chart at first non-zero value in QlikView

Start chart at first non-zero value

evansabres — Thu, 30 Aug 2018 18:57:52 GMT

I have a chart that has a dimension of date and an expression of orders. There are many dates that have a zero value for orders. The application is also built to make a selection first before viewing the chart. (The user makes a selection from a drop-down) After the user makes the selection, I want the chart to start at the first non-zero value as opposed to just the first date in the data set. Is that possible?

Re: Start chart at first non-zero value

ogautier62 — Fri, 31 Aug 2018 10:22:58 GMT

change your dimension as :

something like this :

if(DateOrder >= FirstSortedValue(total DateOrder,if( aggr(sum(expression order),Order>0,DateOrder)), DateOrder)

regards

Re: Start chart at first non-zero value

PrashantSangle — Fri, 31 Aug 2018 10:32:02 GMT

can you explain with sample data? or screen shot of current output and required output.

regards,

Re: Start chart at first non-zero value

evansabres — Fri, 31 Aug 2018 15:19:06 GMT

my fields are:

Dimension: DTE

Metric: TotalOrderValue

In your example, DateOrder would be the dimension? Expression order would be TotalOrderValue?

Re: Start chart at first non-zero value

BalaBhaskar_Qlik — Sat, 01 Sep 2018 09:02:33 GMT

Try some thing like this:

=Max({< DTE={"<=$(=vEndDate)"}>} aggr(firstsortedvalue (Orders, -DTE), Orders))

Add some fields in this expression...

Re: Start chart at first non-zero value

ogautier62 — Mon, 03 Sep 2018 10:03:46 GMT

yes Dateorder would be DTE,

and expression order : TotalOrderValue

regards