Discussion Board for collaboration on QlikView Scripting.
I am struggling with an expression for my pivot table.
For example please have a look at pivot table:
I would like to write an expression which will show me the value of latest week in corresponding month.
Co for example for car ID 910, I would see 80 in Aug, 0 (or null) in Jul, and 91 in September.
Week column is for reference only and in final pivot it will be gone.
I am attaching sample qvw document for your reference.
See attached qvw.
Thanks for reply. This works perfectly when there is no aggregation function in expression. Unfortunetely I need this solution for expression with aggregation function. I will come back with details.