topic Re: Combo Chart - Full Accumulation Limits in QlikView

Combo Chart - Full Accumulation Limits

ZoeM — Sat, 16 Nov 2024 21:07:27 GMT

Hello Community.

I have a glidepath combo chart which shows Planned vs. Delivered product for the year.

I am trying to create limits for both metrics such that the planned line should start in the current month, April in this case, and still be the accumulated amount of planned (Jan through Apr).

The Delivered bars should stop at current month, Apr in this case and not show remaining.

Please see attached application.

Is this possible?

Thanks for the help.

Re: Combo Chart - Full Accumulation Limits

dplr-rn — Wed, 03 Apr 2019 14:45:05 GMT

Quick question why do you have delivered information fro future?

in any case You can do it through set analysis for month
e.g. Month={"<=$(=Month(today()) )"}

but you need to format month appropriatly with dual. i.e. you need to create proper date fields rather than just text (like in your qvw)

Re: Combo Chart - Full Accumulation Limits

ZoeM — Wed, 03 Apr 2019 14:53:58 GMT

Thanks for the reply Dilipranjith.

Yes I put that QVW together quickly for elaboration.

The below is the syntax for my expression in the actual dashboard:

Count({$<[Date Type]={'Del Dates'},Reference_Only={'No'}, [#of Days Post DD]=-{' '}>}Product)

I plugged in your component and I got an error.

Re: Combo Chart - Full Accumulation Limits

dplr-rn — Wed, 03 Apr 2019 15:31:39 GMT

Please share the expression you tried.

Re: Combo Chart - Full Accumulation Limits

ZoeM — Wed, 03 Apr 2019 16:21:54 GMT

Here is my expression:

Count({$<[Date Type]={'Del Dates'},Reference_Only={'No'},YearMonth={"<=$(=Month(today()) )"}, [#of Days Post DD]=-{' '}>}Product)

Re: Combo Chart - Full Accumulation Limits

dplr-rn — Wed, 03 Apr 2019 16:30:58 GMT

Since you are using year month
change the Month(today()) to same format as your YearMonth column
e.g. below
YearMonth={"<=$(date(monthstart(today()), 'MMM-YYYY')"}

Re: Combo Chart - Full Accumulation Limits

ZoeM — Wed, 03 Apr 2019 17:03:43 GMT

Yea still no luck buddy.

My format is MMM YY and I still get an error.

Re: Combo Chart - Full Accumulation Limits

albertovarela — Wed, 03 Apr 2019 17:06:10 GMT

Hello there,

Please take a look at the attached qvw.

A few notes:

I had to create a date field as your original qvw had month as a string
For the planned I used a combination between rangesum and above therefore disabled the full Accumulation on the chart properties
For the Delivered and difference I played with background colour (inside the expression). Made it white
Created a separate chart for the legend as the original one was displaying the last colour on the expression (white)

I hope this helps

Re: Combo Chart - Full Accumulation Limits

dplr-rn — Wed, 03 Apr 2019 17:06:37 GMT

hm.. thats the usual approach but depends on your data too.
i think i missed $(= in the last one.
but if you have sample app or data i can try locally too

Re: Combo Chart - Full Accumulation Limits

ZoeM — Wed, 03 Apr 2019 17:27:46 GMT

Exactly!

But please explain a bit more on how you did this, and please reference my Set Analysis Expression and how I can get the same result as you:

If(YearMonth<Month(Today()),0,
RangeSum(Above( Count({$<[Date Type]={'Del Dates'},Reference_Only={'No'}>}Product) ,0,YearMonth)))

I am not getting the same changes to the chart as you

YearMonth is my date field in the chart

I am counting how many products that were planned have been delivered, by month.

Blue color is Difference

Green color is delivered.

Re: Combo Chart - Full Accumulation Limits

ZoeM — Wed, 03 Apr 2019 18:05:59 GMT

I figured it out. I had to change the formula to MonthStart() instead of Month()...

Thanks guys for all your help!