topic Chart not refreshing when variable used in set analysis is changed? in QlikView

Chart not refreshing when variable used in set analysis is changed?

richard_simpson — Sun, 12 Feb 2012 19:21:08 GMT

Does anyone know what could be the problem, or what I have to do, to get a chart (straight table) to refresh when a variable used by it in set analysis expressions is amended by the user using an input box? By placing a text box alongside the input box I can see that the variable has been changed, but the chart (table) doesn't seem to notice! If I click on the chart and view its properties, and then exit the view of properties using the cancel button, then still no change. But if I view the properties and then exit them by pressing <ok>, even though I haven't amended any properties, the chart now refreshes and the table shows values relating to the new value in the variable? It is all very strange??

Chart not refreshing when variable used in set analysis is changed?

Anonymous — Mon, 13 Feb 2012 00:43:18 GMT

Richard,

It is strange... The only reason I can think of - maybe the chart is "detached" (?)

Chart not refreshing when variable used in set analysis is changed?

Qvmaster2019 — Mon, 13 Feb 2012 03:00:06 GMT

In case it is not "detached", could you attached your .qvw?

Chart not refreshing when variable used in set analysis is changed?

Mon, 13 Feb 2012 07:55:20 GMT

Hi,

I don't know the reason for the application's strange behaviour, but maybe you can use triggers ("on any event", "set variable") as a workaround?

Chart not refreshing when variable used in set analysis is changed?

richard_simpson — Mon, 13 Feb 2012 09:20:32 GMT

Thanks Michael. I did wonder if that was the cause, but had already checked and it isn't. That would have explained it although not sure what does trigger a refresh when an object is detached? (because it does refresh when I view its properties and then exit with <ok>, but not when exiting properties with <cancel>). Anyway, it isn't detached, so not the problem. Thanks though....

Re: Chart not refreshing when variable used in set analysis is changed?

richard_simpson — Mon, 13 Feb 2012 09:25:16 GMT

Hi dnatividad. I'm afraid I can't attach the QVW... it is far too big and also confidential information

But I can assure you it isn't detached.

If I don't get an answer that solves this then I may try to build a very simple QVW with inline tables etc and see if I can replicate the problem....

Incidentally, for some reason your post has amended the AUTHOR of this whole thread? Do you know why? It isn't because you are the last one to post a message because sebablum has posted a message since? Very strange!

Re: Chart not refreshing when variable used in set analysis is changed?

richard_simpson — Mon, 13 Feb 2012 09:26:53 GMT

Hi Sebablum. It's a great idea, and I will try it, but of course I shouldn't really have to! I'll let you know how I get on. Thanks

Chart not refreshing when variable used in set analysis is changed?

CELAMBARASAN — Mon, 13 Feb 2012 09:49:42 GMT

Hi,

Check whether the variable changed?

Are you using any condition or variable value in your chart expression to make change in chart?

Celambarasan

Chart not refreshing when variable used in set analysis is changed?

jagan — Mon, 13 Feb 2012 09:54:56 GMT

Hi,

Check whether variable value is changing by placing it in the Text box. If possible attach the sample file or else post the expressions used for Variable and chart expressions.

Regards,

Jagan.

Chart not refreshing when variable used in set analysis is changed?

Anonymous — Mon, 13 Feb 2012 11:21:32 GMT

Richard,

About the "ok" vs. "cancel" behavior - it is normal. On cancel, nothing happens. On OK, chart recalculates. That's why I thought of "detached".

Speaking of workarounds. See if chart calculates if you detach/attach it without going to chart properties. If it works, you can use a macro that does the same on any select or variable change.

Regards,

Michael

Re: Chart not refreshing when variable used in set analysis is changed?

richard_simpson — Mon, 13 Feb 2012 11:49:00 GMT

Thanks again Michael.

I tried "detach" followed by "attach" and you are right... on the "detach" nothing happens but on the subsequent "attach" the chart refreshed according to the new variable value!

I try not to use MACROS, so I looked at possible triggers that are available and found that by setting a trigger on the change of the variable, and specifying that the action is to "restore" the chart, it works!!

I'm still puzzled why it needs anything to get this to work, why changing the variable in the input box doesn't cause everything to refresh in the same way that making a selection does, but anyway, I have a pretty neat workaround now!

Thanks again

Re: Chart not refreshing when variable used in set analysis is changed?

Qvmaster2019 — Mon, 13 Feb 2012 23:00:20 GMT

No worries Richard. In case you need to attached a qvw file in the future, you can do data reduction (to reduce file size) and scrambling (to protect confidential information)