Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ramanannad
Contributor III
Contributor III
‎2016-04-25 02:58 AM

Pivot daily table to display previous monthend value

Hi Gurus,

I have an requirement where I would like to populate each of the highlighted column below with the previous monthend value :

question.png

Wish to think that my set expression here is correct, but somehow the value in the 2nd column only populates on the row with REPORT_DT=31/3/2016, probably due to the "Max" within the set expression. Removing the "Max" just gives 0 in all rows.

Do advice on how to achieve this. I would like to populate the single value of 31/3/2016 in all the rows with April date and 29/2/2016 value for all the rows with March date and so forth.

Thanks and have a great day

Ram

343 Views
0 Likes
0 Replies