topic Bar Offset not working when refreshing dashboard using automated task in QlikView

Bar Offset not working when refreshing dashboard using automated task

Fri, 15 Jan 2016 18:50:19 GMT

Hi,

I have a dashboard where I am using the Bar Offset feature. The data looks good when working on local machine. Charts are populating as expected. I deployed this dashboard to test server and created a 2 tasks - one to refresh te QVD (getting data from tables) and other to refresh the QVW. The moment when QVW is refreshed.... those bars that have Bar offset calculations written start showing 0 as values...

Does anyone know why this is happening? I am using Qlikview 11.

Re: Bar Offset not working when refreshing dashboard using automated task

swuehl — Fri, 15 Jan 2016 19:50:56 GMT

Could you post this QVW?

Re: Bar Offset not working when refreshing dashboard using automated task

Fri, 15 Jan 2016 20:23:54 GMT

Here is the QVW file for your reference.

Re: Bar Offset not working when refreshing dashboard using automated task

swuehl — Fri, 15 Jan 2016 22:21:14 GMT

Do the variables get resetted when you refresh the QVW on the server?

Re: Bar Offset not working when refreshing dashboard using automated task

Sat, 16 Jan 2016 08:04:43 GMT

No, they are static as you could see in variable section.

Re: Bar Offset not working when refreshing dashboard using automated task

ahmar811 — Sat, 16 Jan 2016 09:19:58 GMT

sushant pandey

try this link for your reference

Waterfall Chart Offest Using Dimensions

Waterfall chart using dimensions‌

hope this help you

Thanks & Regards

Ahmar Ansari

Re: Bar Offset not working when refreshing dashboard using automated task

Mon, 18 Jan 2016 09:08:46 GMT

Hi,

Unfortunately this didn't help because of 2 reasons

I am not using the dimensions in my charts
The issue is that everything is working as expected on local machine. Only when I deploy the QVW on test server and refresh it with help of Task then I am getting 0 as values. Just to clarify, I am using the same data on local machine that I am working with on test server.