Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ishanbansal1204
New Contributor

Weekly and YTD Value in combo chart

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.

26 Replies
MVP
MVP

Re: Weekly and YTD Value in combo chart

Could you share your sample qvw?

ishanbansal1204
New Contributor

Re: Weekly and YTD Value in combo chart

Hi tresesco,

I dont have any.

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

MVP
MVP

Re: Weekly and YTD Value in combo chart

antoniotiman
Honored Contributor III

Re: Weekly and YTD Value in combo chart

Like this

ishanbansal1204
New Contributor

Re: Weekly and YTD Value in combo chart

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

eromiyasimon
Contributor II

Re: Weekly and YTD Value in combo chart

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

antoniotiman
Honored Contributor III

Re: Weekly and YTD Value in combo chart

See Attachment

Regards,

Antonio

ishanbansal1204
New Contributor

Re: Weekly and YTD Value in combo chart

Hi Antonio,

There is no attachment.

antoniotiman
Honored Contributor III

Re: Weekly and YTD Value in combo chart

??

Community Browser