topic Re: Finding MTD values on pivot table. in QlikView

Finding MTD values on pivot table.

poooja — Mon, 18 Feb 2019 04:01:15 GMT

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

Re: Finding MTD values on pivot table.

Anil_Babu_Samineni — Mon, 18 Feb 2019 04:18:31 GMT

Did you read this?

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

Re: Finding MTD values on pivot table.

pradosh_thakur — Mon, 18 Feb 2019 05:28:47 GMT

"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)

Re: Finding MTD values on pivot table.

rahulpawarb — Mon, 18 Feb 2019 09:10:13 GMT

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-Previous-Year/ta-p/1495515

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

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

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

Re: Finding MTD values on pivot table.

poooja — Mon, 18 Feb 2019 12:28:59 GMT

Thanks! i was able to solve this.

Re: Finding MTD values on pivot table.

poooja — Mon, 18 Feb 2019 12:29:19 GMT

Thanks!