topic Re: qlikview expression value is blank on open. Shows values after fresh in QlikView

qlikview expression value is blank on open. Shows values after fresh

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have an expression with FieldValue function.

The values are blank when I open the dashboard. However when I refresh it the values show up.

Anyone knows a solution to fix it?

Bharath.

Attached the qlikview and source data excel files. Hope this helps.

Re: qlikview expression value is blank on open. Shows values after fresh

vishsaggi — Fri, 09 Jun 2017 17:03:41 GMT

Where are you using this function? Can you send some more information on this?

Re: qlikview expression value is blank on open. Shows values after fresh

Sergey_Shuklin — Fri, 09 Jun 2017 17:04:00 GMT

Hello, Bharath!

This issue can appear occasionally if you use a lot of objects. I heard removing rarely used objects (or even objects in temporary Sheets) can help to solve the issue. So, look for way of reducing objects. I think it will help!

Re: qlikview expression value is blank on open. Shows values after fresh

tajmohamed30 — Fri, 09 Jun 2017 17:05:55 GMT

you can reload on open to display the values, follow the steps in the link below

Auto reload on open

hope it helps

Re: qlikview expression value is blank on open. Shows values after fresh

Anonymous — Fri, 09 Jun 2017 18:09:40 GMT

I have only one straight table in the sheet.

I tried the "reload on open" and that didnt work either.

Something wierd is happening.

Re: qlikview expression value is blank on open. Shows values after fresh

tajmohamed30 — Fri, 09 Jun 2017 18:23:19 GMT

have you tried creating new document similar to the one where you have some problem and check whether it is coming without any issues

Re: qlikview expression value is blank on open. Shows values after fresh

Sergey_Shuklin — Fri, 09 Jun 2017 19:12:23 GMT

Hm, I've opened you project several times and values are there. Can you open it in other computer?

Re: qlikview expression value is blank on open. Shows values after fresh

tajmohamed30 — Fri, 09 Jun 2017 19:18:42 GMT

yes please

Re: qlikview expression value is blank on open. Shows values after fresh

Anonymous — Fri, 09 Jun 2017 19:19:41 GMT

I tried. This is what I see when I open the dashboard. Is there any settings/preferences that I need to change?

Re: qlikview expression value is blank on open. Shows values after fresh

tajmohamed30 — Fri, 09 Jun 2017 20:23:01 GMT

Please have a look attached document, I have enabled macro to reload on open

Regards

Taj Mohamed

Re: qlikview expression value is blank on open. Shows values after fresh

Anonymous — Fri, 09 Jun 2017 20:38:13 GMT

Hi,

This helps when I open the dashboard in qlikview.

However when I open the dashboard in browser (which is what the users will be doing), its still blank.

How can I resolve that?

Re: qlikview expression value is blank on open. Shows values after fresh

Sergey_Shuklin — Sat, 10 Jun 2017 05:58:48 GMT

Yeah, macroses don't work on access point - it's sad. Did you try some logical hints like place an equal sign or multipy by 1:

=FieldValue( 'baselineimpressions', FieldIndex( 'baselineposition', Round( Avg( position ) ) ) )*1

may be this will force the calculation to work?

Re: qlikview expression value is blank on open. Shows values after fresh

tajmohamed30 — Sat, 10 Jun 2017 08:31:30 GMT

Think you are messing around with logic

pls check field value and field index explination pls? | Qlik Community

Re: qlikview expression value is blank on open. Shows values after fresh

passionate — Sat, 10 Jun 2017 16:51:42 GMT

Instead of using field value and field index Try using ONLY function:

something like:

=Only({<baselineposition={"=Round( Avg( position ) ) "}>}baselineimpressions)

Re: qlikview expression value is blank on open. Shows values after fresh

Anonymous — Mon, 12 Jun 2017 17:07:06 GMT

Found the solution!!!

I dont know why...but the issue seems to be with the FieldIndex function and not the FieldValue function.

So this is what I did.

In my query I sorted the baseline table by baseline position (ascending) and then I changed my calcuation to

FieldValue( 'baselineimpressions', Round( Avg( position ) ) )

This worked all the time and also showed the values when I accessed it in Access Point through my browser.

P.S.: I am still curious to find out why the FieldIndex didnt work with a calculation. It worked when I just hardcored an integer like FieldValue( 'baselineimpressions', FieldIndex( 'baselineposition', 1) )

Re: qlikview expression value is blank on open. Shows values after fresh

Sergey_Shuklin — Mon, 12 Jun 2017 17:29:39 GMT

It's great 😃 Glad you'd found the solution!

Re: qlikview expression value is blank on open. Shows values after fresh

oscar_ortiz — Tue, 13 Jun 2017 13:07:12 GMT

Very odd situation indeed.

I go around the situation by adding another expression to the chart and hiding it.

In the 1st example I've taken care of the issue by adding and hiding an expression.

In the 2nd chart I show the expression.

In the 3rd chart I change the position of the expression and you can see that it breaks the other expressions again.

Good luck

Oscar