topic Re: AsofTable in QlikView

AsofTable

prasadcm — Thu, 19 May 2016 05:01:33 GMT

Rangesum with Aggr?

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

stalwar1‌

gwassenaar‌

Re: AsofTable

prasadcm — Thu, 19 May 2016 05:08:28 GMT

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 !

Re: AsofTable

sunny_talwar — Thu, 19 May 2016 09:40:20 GMT

What is different in this version of the application?

Re: AsofTable

prasadcm — Thu, 19 May 2016 09:46:35 GMT

This is the actual version i m working upon

Re: AsofTable

sunny_talwar — Thu, 19 May 2016 10:01:01 GMT

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

Re: AsofTable

prasadcm — Thu, 19 May 2016 10:15:55 GMT

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.

Re: AsofTable

sunny_talwar — Thu, 19 May 2016 10:19:07 GMT

Check here:

Uploading a Sample

Re: AsofTable

prasadcm — Thu, 19 May 2016 10:52:08 GMT

Hi stalwar1‌

Re: AsofTable

sunny_talwar — Thu, 19 May 2016 11:20:20 GMT

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.