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: 
csmqlik01
Contributor III
Contributor III

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

9 Replies
OmarBenSalem

Please refer to this thread:

YTD, MTD issue

sunny_talwar

May be this?

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


Capture.PNG

OmarBenSalem

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.

sunny_talwar

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

OmarBenSalem

I just want him to understand how to write time expressions

csmqlik01
Contributor III
Contributor III
Author

Thanks Omar, I will read this and try it out

csmqlik01
Contributor III
Contributor III
Author

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

Both thanks for the quick answer !!

csmqlik01
Contributor III
Contributor III
Author

Hi Sunny, thanks for answer it works well

@ Omar , I will sure read your answer

Thanks

csmqlik01
Contributor III
Contributor III
Author

Hi Sunny,

this works fine if there is data for all months , but I have periods with no data and then a get a dashin YTD, and by the next actual value i get a value in YTD again, but now the user wants, if no actual value  to see a copy of  the  value before in YTD.

How can we proceed with months  with no value,  with  if(… )  maybe ?

Can you help on this

Best regards