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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.