topic Re: Burndown by date help in QlikView

Burndown by date help

Tue, 20 Jun 2017 10:26:30 GMT

Morning All,

I have a field that is basically a month field, some of the contents of this field are invalid and I have declared them as 'No Forecast'

What I wish to do is start at my total and burn down by month until I reach my No forecast total.

I'm think I am very close but I am obviously missing something. Also my data always seems to want to put No Forecast first when I want it last. Can I force a load order to always but a certain content last no matter what the preceding data is?

The simply count of my Forecast_Month field looks like this, so basically I am trying to get from 116 to 34.............

Re: Burndown by date help

prat1507 — Tue, 20 Jun 2017 11:04:05 GMT

Hi Graham

You can load an inline table as

Dim:

LOAD * Inline [

XDim

];

Use this in the dimension field as pick(Xdim, FORECAST_MONTH, 'Total')

in the expression write:

pick(Xdim, count([A/C_Tail_Number]), count({<FORECAST_MONTH=>}[A/C_Tail_Number]))

You can force the load order to always but a certain content last no matter what the preceding data by using Wildmatch.

Use Wildmatch(FORECAST_MONTH,'No Forecast') in expression is sort and set the

order as descending.

Regards

Pratyush

Re: Burndown by date help

sunny_talwar — Tue, 20 Jun 2017 11:06:42 GMT

Would you be able to share a sample to look at what you have?

Re: Burndown by date help

Tue, 20 Jun 2017 13:08:25 GMT

Afternoon,

If I follow your steps I result in the below:

While waiting for replies I did have some of my own success with the following Expression:

count(Total(FORECAST_MONTH))- Rangesum(above(Total count(FORECAST_MONTH),0,RowNo(total)))

This results in the following:

Which is close to what I am after but I would ideally like to start on my total of 116.

Re: Burndown by date help

sunny_talwar — Tue, 20 Jun 2017 13:11:01 GMT

How about this

Count(TOTAL FORECAST_MONTH) - RangeSum(Above(TOTAL Count(FORECAST_MONTH), 1, RowNo(TOTAL)))

Re: Burndown by date help

Tue, 20 Jun 2017 13:14:52 GMT

I was so close!!

Although you left a bracket in yourself 😉

Thank You

Graham

Re: Burndown by date help

sunny_talwar — Tue, 20 Jun 2017 13:19:43 GMT

Yes I did, fixing that now

Re: Burndown by date help

sunny_talwar — Tue, 20 Jun 2017 13:20:38 GMT

In fact, you only seems to have a single dimension... this should work also (without TOTALs)

Count(TOTAL FORECAST_MONTH) - RangeSum(Above(Count(FORECAST_MONTH), 1, RowNo()))

Re: Burndown by date help

Tue, 20 Jun 2017 13:32:09 GMT

That works too.