Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
mhappiee
New Contributor III

YTD calculation

Hi

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





Regards,

mhappiee