Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
MVP
MVP

Could you share your sample qvw?

Highlighted
Contributor II
Contributor II

Hi tresesco,

I dont have any.

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

Highlighted
MVP
MVP

Highlighted
Master III
Master III

Like this

Highlighted
Contributor II
Contributor II

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

Highlighted
Creator II
Creator II

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

Highlighted
Master III
Master III

See Attachment

Regards,

Antonio

Highlighted
Contributor II
Contributor II

Hi Antonio,

There is no attachment.

Highlighted
Master III
Master III

??