topic Re: Table chart not refreshing following variable value change in App Development

Table chart not refreshing following variable value change

Mike8 — Thu, 18 Aug 2022 09:45:50 GMT

Hi. I have several table charts that display data based on a variable value in a calculated dimension, eg:

=if([Manager ID] = vUserPersonnelNumber, [Personnel Number])

If I change the variable value all charts automatically update to calculate with the new variable value. Except for one chart. I can't figure out why it is not updating like the others. The If statement is formulated in the same way. Is there a setting I can check that enables auto-refresh or something?

If I refresh the browser the chart reloads to display correctly. So it is calculating fine, it just will not refresh after I change the variable value, even though the others will.

Thanks!

Re: Table chart not refreshing following variable value change

JHuis — Thu, 18 Aug 2022 11:26:34 GMT

Try this:

=if([Manager ID] = $(vUserPersonnelNumber), [Personnel Number])

Re: Table chart not refreshing following variable value change

Mike8 — Fri, 19 Aug 2022 08:08:23 GMT

Thanks, the $() makes the chart refresh, fixing this issue. But can anyone explain why this is not required on some other charts that refresh automatically?

Here are the full dimension expressions for two table charts. One has $() and the other does not, but both refresh automatically. When the $() is taken out that chart will not refresh after a vUserPersonnelNumber variable value change, but the other charts will refresh.

=if([Event Date]>=today()-14
and ( [Event Manager ID] = $(vUserPersonnelNumber) or ($(vDirectReports)=0 and [Event Senior Manager ID] = $(vUserPersonnelNumber)) )
,[Event Date])

=if ( [Employment Status] = 'Active'
and [Action Start Date] <= today()
and [Action End Date] >= today()
and ([%Manager ID] = vUserPersonnelNumber or (vDirectReports=0 and [%Senior Manager ID] = vUserPersonnelNumber))
and [Position Start Date] <= today()
and [Position End Date] >= today()
and [CC From Date] <= today()
and [CC To Date] >= today()
, [%Personnel Number])

Is it best practice to always use $() with variables in expressions?

Re: Table chart not refreshing following variable value change

JHuis — Fri, 19 Aug 2022 08:19:18 GMT

Dear Mike,

Its an indication to the qlik engine resolve the expression between the $() , replace with the resulting values, before evaluating the expression.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Magic-of-Dollar-Expansions/ba-p/1471979

I hope this helps?

Is it best practice to always use $() with variables in expressions?

Yes., but it depends in the situation. I use variables more to make a filter on date or variabel input. So then you always need the $()

Re: Table chart not refreshing following variable value change

Mike8 — Wed, 24 Aug 2022 07:56:39 GMT

Thank you for your help!