Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Burndown by date help

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.............

1 Solution

Accepted Solutions
MVP
MVP

Re: Burndown by date help

How about this

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

8 Replies
prat1507
Valued Contributor

Re: Burndown by date help

Hi Graham

You can load an inline table as

Dim:

LOAD * Inline [

XDim

1

2

];

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

MVP
MVP

Re: Burndown by date help

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

Not applicable

Re: Burndown by date help

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.

MVP
MVP

Re: Burndown by date help

How about this

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

Not applicable

Re: Burndown by date help

I was so close!!

Although you left a bracket in yourself ;-)

Thank You

Graham

MVP
MVP

Re: Burndown by date help

Yes I did, fixing that now

MVP
MVP

Re: Burndown by date help

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()))

Not applicable

Re: Burndown by date help

That works too.

Community Browser