Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Display Value during Reload

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.

DisplayValue.jpg

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

DisplayValueExpression.jpg

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:

DisplayValueSelectText.jpg

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

DisplayValueAll.jpg

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

DisplayValueActions.jpg

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

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

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

View solution in original post

11 Replies
petter
Partner - Champion III
Partner - Champion III

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?

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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


Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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

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.

Not applicable
Author

Hi Petter,

I applied the expression. This worked perfectly fine.

Thanks,