bar chart

[koguma]

After many rounds of trial and errors, i am almost there in getting what i want, just one more problem left ( i hope).

As shown in the data below,

For Jun-2019, I need to use '84' - '1' (Mar-2019 value)

For Jul-2019, I need to use '84' - '1' - '1' (Mar-2019 value and Jun-2019 value)

For Sep-2019, I need to use '84' - '1' - '1' -'2' (Mar-2019 value, Jun-2019 value, Jul-2019 value)

How can I do this in Qlik Sense? 

[JordyWegman]

Hi Koguma,

Try this:

RangeSum(Above(TOTAL Sum(expiration_date_gmt)*-1, 0, RowNo(TOTAL)))

Jordy

Climber

[sunny_talwar · Accepted solution]

May be something like this

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

[koguma]

Hi Sunny, thanks for the help.

It seems to work so far, but I need to test with more data so as to confirm it is really working.

One more question. How can I show the exact number, instead of the rounding number in the bar chart?

Example of showing 4.57k, I want it to show as 4570. 

[koguma]

Hi Jordy

Thanks for the help. However the result is not what I want. I will explore your solution further and see how I can use it in the future.

Mike