Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table expression for value of top week.

Hello,

I am struggling with an expression for my pivot table.

For example please have a look at pivot table:

1.png

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.

BR,

Kuba

2 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

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.