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: 
prasadcm
Creator II
Creator II

AsofTable

Rangesum with Aggr?

Was not able to attach QVW.so created a new thread

stalwar1

gwassenaar

8 Replies
prasadcm
Creator II
Creator II
Author

Hi gwassenaar,

I went through ur link,I m finding it difficult to implement it in my app.

I created AsOf table & linked it to my table through PostingDate i.e Period1

I have added expression to Balance as: sum({<PeriodType={'Rolling 3'}>}Amount).


I have attached qvw,can u let me know where im going wrong.


Changes are made in 'Copy of Bank Balance Report' tab.


Regards,

Prasad !

sunny_talwar

What is different in this version of the application?

prasadcm
Creator II
Creator II
Author

This is the actual version i m working upon

sunny_talwar

So once again before I think of anything, you can to accumulate for every Bank Name?

prasadcm
Creator II
Creator II
Author

I am not getting what ur trying to say...

Example posted here is as per Gysbert suggestions..

I m trying to upload qvw as per ur suggestions,bt thereseems to be some problem while uploading.

sunny_talwar

Check here:

Uploading a Sample

prasadcm
Creator II
Creator II
Author

Hi stalwar1

sunny_talwar

The actual scenario is much more complicated than what I imagined. I will try to work on this over the weekend. Hopefully some one else can help you out before than.