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

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Prob regarding As Of Table

Hey,

I tried implementing the As Of Table functionality but i am confused about the output that comes. In attached .qvw, in 5th column can anyone help me understanding how this outcome comes? and why the last column expression behaving like 1st column?

Thanks

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

As HIC stated in his blog post, you should use a master calendar showing all dates to build your As-Of-table upon.

And then use AsOfMonth as dimension in your chart.

View solution in original post

5 Replies
Chanty4u
MVP
MVP

swuehl
Champion III
Champion III

Can't see any attachment.

nikhilgarg
Specialist II
Specialist II
Author

Hey,

I am sorry for that.Please see the attachment .

Thanks

swuehl
Champion III
Champion III

As HIC stated in his blog post, you should use a master calendar showing all dates to build your As-Of-table upon.

And then use AsOfMonth as dimension in your chart.

nikhilgarg
Specialist II
Specialist II
Author

Thanks swuehl.