How to Display Value during Reload

[#1]

Hi,

I want to display value in a Text object during Reload. But for some reason unless I select an input parameter, the expression does not display the value.

1. The table is Room and Status. Output is a Text object Room Status.

2. In the Text object Room Status, the expression is:

3. When you do Reload, I expected the above expression to display "OK" status for Room 1. The "Test Object Room Status" displays blank.

The only way the above Text Object expression displays the "OK" status is, if I select "Room 1" value in the "Select Rooms", as shown below:

4. I want to display three Text Object that displays status for three rooms during reload, without clicking each room.

5. I also tried "Actions" tab, but it does not work during Reload.

Can someone please suggest and advise how to display all three Room status during Reload? I have done this for other Qlik programs and they work fine. I am not able to figure out why it work in one program, and not the other.

Thanks,

Raghu

[petter]

Reload is not connected to you UI all the time you are doing a reload in fact. I am pretty sure it is totally disconnected so any updates will be delayed until the reload is completed.

Are you talking about the Desktop version - not a server side reload or anything?

[#3]

During reload you can not show those values.Reload has nothing to do with the UI.

Untill and unless you will select something ,you cant show those values.

Hoping it will help you.

[petter]

You can however store something from the UI into a variable and then show the value of the variable during reload and at the end replace it with something else - a final value.

The variables survive a reload and will be updated (when the reload finish) if they are referenced and changed in the reload process.

But you will not get updates displayed during the reload.

So you could store something into a variable via a button/text object and an action and then trigger a reload as an action... but not dynamically updated as long as the reload is running ...

[#5]

Hi,

Thanks for all the responses. I want to display the status for all three rooms at the same time. How can this be achieved without having to select input "room" from UI? The Reload function does run other expressions for all other text objects in the UI. During Reload, the color changes, the tables get updated, and icons get updated. Why can't UI run the expression defined in the "Text Object"? This is strange.

Raghu

[#6]

As you have multiple values in status(i.e OK,Error),you cant show all the status values in the text object.

You can show it in any chart by using trigger on opening the document.

[petter · Accepted solution]

You can use the expression like this:

=MinString( { 1 <Rooms={'Room 1'} > } Status )

=MinString( { 1 <Rooms={'Room 2'} > } Status )

=MinString( { 1 <Rooms={'Room 2'} > } Status )

In each of your corresponding text boxes ... that will keep their status during reload but not updated until the reload has finished ....

[#8]

Hi Petter,

I appreciate your response. I am using the Desktop version. I believe I have done this in one of my previous Qlikview program. I am unable to locate it. I find it interesting that all other expressions such as Changing Color, Updating tables are updated in UI during the Reload. Why can't this not get executed? I will use suggestions mentioned in yor second response.

Thanks,

[morganaaron]

Confused by your use of the word 'reload' here. Do you mean DURING the reload you want these to update? Or after it reloads?

There are various ways you could do this - you already have a table showing the values though, isn't that enough? If you wanted only one value, you could use set analysis to restrict it to that given Room for example.

[#10]

Hi Petter,

I applied the expression. This worked perfectly fine.

Thanks,