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

[Anonymous]

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.

[Anonymous]

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?

[Sergey_Shuklin]

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?

[tajmohamed30]

Think you are messing around with logic

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

[passionate]

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

something like:

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

[Anonymous]

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) )

[Sergey_Shuklin]

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

[oscar_ortiz]

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