Finding MTD values on pivot table.

[poooja]

Hi Qlikies,

I need a help help in finding  Todays's,MTD,QTD and YTD  values of Qty on pivot table.
Also these values should not change when i do any selections in the dashboard. Attached is the qvw. Hope someone will help me here..

Thanks!

Pooja

[Anil_Babu_Samineni]

Did you read this?

https://community.qlik.com/t5/QlikView-Documents/YTQ-QTD-MTD-and-WTD/ta-p/1489245

[pradosh_thakur · Accepted solution]

hi

"1" is used inside set analysis so the value doesn't change with selection

You need a date field calculate the mtd

try something similar below and replace your field names

YTD

sum({1<Date_field={">=$(=yearstart(today())) <=TODAY()"}>}Qty_field)

MTD

sum({1<Date_field={">=$(=Monthstart(today())) <=TODAY()"}>}Qty_field)

QTD

sum({1<Date_field={">=$(=Quarterstart(today())) <=TODAY()"}>}Qty_field)

[rahulpawarb]

Please refer the attached application file.

Hope this will help!

- Rahul 

Reference(s):

https://community.qlik.com/t5/QlikView-Documents/Date-Level-Analysis-WTD-MTD-QTD-YTD-Current-Year-Pr...

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Da...

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Da...

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Da...

[poooja]

Thanks! i was able to solve this.

[poooja]

Thanks!