Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
poooja
Creator
Creator

Finding MTD values on pivot table.

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

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

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)

Learning never stops.

View solution in original post

5 Replies
Anil_Babu_Samineni

Did you read this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pradosh_thakur
Master II
Master II

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)

Learning never stops.
poooja
Creator
Creator
Author

Thanks! i was able to solve this.
poooja
Creator
Creator
Author

Thanks!