Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

How about this

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

View solution in original post

8 Replies
prat1507
Specialist
Specialist

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

sunny_talwar

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

Not applicable
Author

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.

sunny_talwar

How about this

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

Not applicable
Author

I was so close!!

Although you left a bracket in yourself 😉

Thank You

Graham

sunny_talwar

Yes I did, fixing that now

sunny_talwar

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
Author

That works too.