Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

csmqlik01
New Contributor II

QlikSense : Need to create YTD column in Pivot table

Hi All,

I have a data sheet (Stocklist)  with example data and less columns

I made in Data Manager a new measure YTD, but I can't find the right expression for a YTD

Can anyone help me out on this, I included the data and the QVF

Tags (1)
8 Replies
omarbensalem
Esteemed Contributor

Re: QlikSense : Need to create YTD column in Pivot table

Please refer to this thread:

YTD, MTD issue

MVP
MVP

Re: QlikSense : Need to create YTD column in Pivot table

May be this?

RangeSum(Before(Sum(Value), 0, ColumnNo()))


Capture.PNG

omarbensalem
Esteemed Contributor

Re: QlikSense : Need to create YTD column in Pivot table

But Sunny, that would only work if the order of the Period is maintained.

Well, It would work, but Eddy, try to understand how to create time functions.

MVP
MVP

Re: QlikSense : Need to create YTD column in Pivot table

Why do you think that period will not be sorted? Not sure I understand your concern

omarbensalem
Esteemed Contributor

Re: QlikSense : Need to create YTD column in Pivot table

I just want him to understand how to write time expressions

csmqlik01
New Contributor II

Re: QlikSense : Need to create YTD column in Pivot table

Thanks Omar, I will read this and try it out

csmqlik01
New Contributor II

Re: QlikSense : Need to create YTD column in Pivot table

Hi Sunny,  I will also try your solution,  let's see what  the best

Both thanks for the quick answer !!

csmqlik01
New Contributor II

Re: QlikSense : Need to create YTD column in Pivot table

Hi Sunny, thanks for answer it works well

@ Omar , I will sure read your answer

Thanks