topic Re: Weekly and YTD Value in combo chart in QlikView

Weekly and YTD Value in combo chart

ishanbansal1204 — Tue, 08 Nov 2016 08:58:33 GMT

Hi Experts,

I have a combo chart where the dimensions are week and then the first measure that i am using is the sum(count) at a week level

but i am not getting the YTD value

e.g.

for weeek 1 value will be 10 and YTD will be10

for week 2 value will be 20 and YTD will be 30

THis should be grouped at week and year level.

I have attached the sample file.

Re: Weekly and YTD Value in combo chart

tresB — Tue, 08 Nov 2016 09:08:51 GMT

Could you share your sample qvw?

Re: Weekly and YTD Value in combo chart

ishanbansal1204 — Tue, 08 Nov 2016 09:12:37 GMT

Hi tresesco,

I dont have any.

Have one which has my project. I am sorry cannot share you those details.

Re: Weekly and YTD Value in combo chart

tresB — Tue, 08 Nov 2016 09:15:32 GMT

You can create a sample and upload. Check this :

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Re: Weekly and YTD Value in combo chart

antoniotiman — Tue, 08 Nov 2016 09:32:24 GMT

Like this

Re: Weekly and YTD Value in combo chart

ishanbansal1204 — Tue, 08 Nov 2016 09:54:17 GMT

I Have shared the Excel file. you want me to share the qvf file as well?

Re: Weekly and YTD Value in combo chart

eromiyasimon — Tue, 08 Nov 2016 09:56:30 GMT

Hi,

The below expression shows the value which you requested.

rangesum(Above(Total sum(COUNT),0,RowNo(Total)))

attached the QVW for further reference.

Hope this helps

Re: Weekly and YTD Value in combo chart

antoniotiman — Tue, 08 Nov 2016 10:12:52 GMT

See Attachment

Regards,

Antonio

Re: Weekly and YTD Value in combo chart

ishanbansal1204 — Tue, 08 Nov 2016 11:14:59 GMT

Hi Antonio,

There is no attachment.

Re: Weekly and YTD Value in combo chart

antoniotiman — Tue, 08 Nov 2016 11:19:18 GMT

Re: Weekly and YTD Value in combo chart

ishanbansal1204 — Tue, 08 Nov 2016 11:35:34 GMT

Thanks for the file.

But in the file that you had shared

apply filter on date and select last few weekyear filter

in that case YTD values are calculated based on the filter selected but that should not be the case.

Please find the updated file and let me know.

Thanks.

The attachment is in the main tread.

Re: Weekly and YTD Value in combo chart

ishanbansal1204 — Tue, 08 Nov 2016 12:16:44 GMT

Hi Eromiya Simon,

This will work fine if no filters are applied. if i apply filter on week and select few weeks then YTD values are calculated only for the selected week but YTD has to be calculated irrespective of the week selected.

Re: Weekly and YTD Value in combo chart

eromiyasimon — Tue, 08 Nov 2016 12:23:35 GMT

you can use this expression

Sum(Aggr(rangesum(Above(Total sum({<WEEK>} COUNT),0,RowNo(Total))),WEEK))

you can simply detach the chart or you can setup alternative state to preserve the values being changed while the selection has been made.

Re: Weekly and YTD Value in combo chart

tresB — Tue, 08 Nov 2016 12:25:18 GMT

In that case, try the expression below:

Sum(Aggr(rangesum(Above(Total sum({<WEEK>} COUNT),0,RowNo(Total))),WEEK))

Re: Weekly and YTD Value in combo chart

antoniotiman — Tue, 08 Nov 2016 13:23:44 GMT

See Attachment

Re: Weekly and YTD Value in combo chart

ishanbansal1204 — Wed, 09 Nov 2016 05:08:44 GMT

Not Working. Showing some incorrect values.

Re: Weekly and YTD Value in combo chart

ishanbansal1204 — Wed, 09 Nov 2016 05:08:56 GMT

Not Working. Showing some incorrect values.

Re: Weekly and YTD Value in combo chart

ishanbansal1204 — Wed, 09 Nov 2016 05:10:28 GMT

Hi Antonio,

The calculation was done in the load script as per your file that you shared.

Is there any possibility that i can use some calculation in the measure or in the dashboard itself rather than in the load script.?

Re: Weekly and YTD Value in combo chart

eromiyasimon — Wed, 09 Nov 2016 05:19:08 GMT

hi ishan,

i donno why you are getting error,

use the attached QVW.

Re: Weekly and YTD Value in combo chart

tresB — Wed, 09 Nov 2016 05:24:05 GMT

Since your dimension is WeekYear, you have to change the expression accordingly like:

Sum(Aggr(rangesum(Above(Total sum({<WeekYear>} COUNT),0,RowNo(Total))),WeekYear))