Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YTD problems - already checked out 10 examples...

Hi all,

I have tried all the options and I had a few successes with this, but unfortunately I can't find the answer to my problem.

I am trying to make a chart with YTD (In PIVOT table layout). However, the functions do not work properly. Whichever one I try

See attached example

Thanks in advance for your help!

1 Solution

Accepted Solutions
pover
Luminary Alumni
Luminary Alumni

Try the following function in your pivot table

rangesum(before(sum(OMZET),0,12))

Set analysis doesn't work when the set anaylsis is done over fields that are defined as dimensions.

Regards.

View solution in original post

2 Replies
pover
Luminary Alumni
Luminary Alumni

Try the following function in your pivot table

rangesum(before(sum(OMZET),0,12))

Set analysis doesn't work when the set anaylsis is done over fields that are defined as dimensions.

Regards.

Not applicable
Author

PERFECT !!! I think this will work!