want to add an excel which i have created in qlikview application again in other application

[ferha_jafri]

Hello Everyone,

I am facing a performance issue, i have a report in which i am creating SIH by using rangesum function so it is taking a lot of time to load, so i want to fetch that report and call that report in my final qvw so that the calculation happen only once but the result is not coming correctly.Please suggest what i can do.

Thanks in advance

Ferha Jafri

[kaushiknsolanki]

Hi,

     I didnt understand fully, can you please elaborate with example.

Regards,

Kaushik Solanki

[ferha_jafri]

Hello,

I am working on inventory dashboards in which i am creating a report wrt to branch plant, dg category,dg item code and fg code , fg code is coming from a different table , rest are coming from other table.I am calculating in hand stock which i am calculating through rangesum as the closing is becoming the opening for the next day.The issue is that this report is taking a lot of to to generate so i want to fetch that report in excel and do the sum of SIH so that it will take less time.

[kaushiknsolanki]

Hi,

     So are you doing this in script or in chart?

Regards,

Kaushik Solanki    

[ferha_jafri · Accepted solution]

i am getting this in the chart the expression which i am using is

rangesum(above(sum(Quatity),0,rowno(Total))

[kaushiknsolanki]

Hi,

     Its better then you try to calculate the same in script.

Regards,

Kaushik Solanki

[#7]

Hi Ferha,

As per my understanding, you want to apply some logic on the besic data which you are doing in frontend (Chart),

One way to do this, just export your chart to some place and then use that exported data directly into another Qlikview application and this process is recrusive means whenever there is new export your another QV app will get reloaded with the help of some trigger and you will get a new exported data in it.

I hope you want this!!!

Please feel free for any explanation..

Regards,

Yojas