Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
After selecting the month value: (But here my expectation is pivot table should show only feb value)
Please check Script Editor, variables and the new expression.
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