Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
poooja
Creator
Creator

MTD ,QTD,YTD in Pivot Table

Hi Friends,

I need a help on finding MTD,QTD,YTD values in Pivot Table. I have written a code for MTD but it is  Currently it showing overall quantity. i need only current month qty (Ex; February month value only)
Also this value should not change when i select the months in the dashboard. But the values are changing when i select a month. Attached is the qvw. Hope someone will help me here..

 

Thanks!

Pooja

Before selecting any month: 

Capture1.PNG

 

After selecting the month value: (But here my expectation is pivot table should show only feb value)

Capture.PNG

2 Replies
Claudiu_Anghelescu
Specialist
Specialist

Please check Script Editor, variables and the new expression.

 

 

To help community find solutions, please don't forget to mark as correct.
poooja
Creator
Creator
Author

Thanks for your response. 

I have  another table which has the field YearMonth. When i select YearMonth this code is not working. Also i need to know how to calculate Day to day,QTD,YTD  on the same table in a separate column.

Please help me here.  I have attached the updated Qlik file.

 

Thanks!
Pooja