Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
koguma
New Contributor

bar chart

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? 

aaa.png

1 Solution

Accepted Solutions

Re: bar chart

May be something like this

Count(TOTAL expiration_date_gmt) - RangeSum(Above(Count(expiration_date_gmt), 1, RowNo()))
4 Replies
Partner
Partner

Re: bar chart

Hi Koguma,

Try this:

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

Jordy

Climber

Work smarter, not harder

Re: bar chart

May be something like this

Count(TOTAL expiration_date_gmt) - RangeSum(Above(Count(expiration_date_gmt), 1, RowNo()))
koguma
New Contributor

Re: bar chart

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. 

Capture.JPG

koguma
New Contributor

Re: bar chart

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