Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Honored Contributor

YTD problems - already checked out 10 examples...

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.

2 Replies
pover
Honored Contributor

YTD problems - already checked out 10 examples...

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

YTD problems - already checked out 10 examples...

PERFECT !!! I think this will work!

Community Browser