Discussion Board for collaboration on QlikView Scripting.
I am getting the rollup sum value for every month .In a pivot table i need to show the latest month only by quarter wise .
Now i want to display in this way using Pivot Table show only the latest month in Total
Go to Solution.
PFA of Solution.
can you please make it crear what you want exactly?
I have attached Qvw file in that file a pivot table is created . In pivot table the SUb total for monthName should be shown for latest month.
In my calendar November is the starting Month.
For Q1 the subtotal should be Jan Value
Q2 Apr Value
Q3 Jul Value
Q4 Oct Value
Did you understand my requirement?
U HAD THAT QUARTER KA ANSWER