Skip to main content
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

YTD calculation


How to get YTD in Straight table as an additional measure  along with Monthly sales measure in Qliksense

To Detail:

I have Data like

Yearmonth, Volume, Client name, product type

attached has the sample data and I want to calculate YTD and the pct difference along with the last 13 months volume

was able to use set analysis to get the sum for YTD but when I add that in pivot that is getting split by Year month  like below

Cname ,                                          year month                                            YTD

                             Jan 2017|Feb 2017|.....|Jan 2018|Feb 2018    Jan 2017|Feb 2017|.....|Jan 2018|Feb 2018

Arun                         10 |20.....|30|40                                                       10 |20.....|30|40

Asha                         30 |40.....|20|10                                                       30 |40.....|20|10

Can some body help me out to get the YTD and pct difference as Given in the excel

Thanks for all your help ahead



0 Replies