Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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
MVP
MVP

Can't see any attachment.

nikhilgarg
Specialist II
Specialist II
Author

Hey,

I am sorry for that.Please see the attachment .

Thanks

swuehl
MVP
MVP

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.