topic Re: How to prepare pivot table have data MTD and YTD? in QlikView

How to prepare pivot table have data MTD and YTD?

panwipa2528 — Sat, 16 Nov 2024 03:20:44 GMT

1. I have daily raw data from 2 persons. (Data since 1/1/2018-28/5/2019)
2. I want to know sum(Sale) from 1-28 May 2018 & 1-28 May 2019
3. I want to know sum(Sale) from 1-Jan - 28 May 2018 & 1-Jan - 28 May 2019
4. Need to see 2 & 3 same table

Re: How to prepare pivot table have data MTD and YTD?

PrashantSangle — Tue, 11 Jun 2019 03:44:41 GMT

Hi,

Avoid duplicate thread .
https://community.qlik.com/t5/QlikView-App-Development/How-to-prepare-pivot-table-have-data-MTD-and-YTD/m-p/1590236#M443502

https://community.qlik.com/t5/QlikView-App-Development/How-to-prepare-pivot-table-have-data-MTD-and-YTD/m-p/1590237#M443503

Delete any one of it.

Regards,
Prashant Sangle

Re: How to prepare pivot table have data MTD and YTD?

Vegar — Tue, 11 Jun 2019 04:16:06 GMT

Good morning.
Take a look at this post by @rahulpawarb , I believe it covers what you want to do.
https://community.qlik.com/t5/QlikView-Documents/Date-Level-Analysis-WTD-MTD-QTD-YTD-Current-Year-Previous-Year/ta-p/1495515

Re: How to prepare pivot table have data MTD and YTD?

panwipa2528 — Tue, 11 Jun 2019 07:07:43 GMT

Thank you for your help.