topic Re: How to Display Value during Reload in QlikView

How to Display Value during Reload

Fri, 17 Apr 2015 14:30:19 GMT

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

Re: How to Display Value during Reload

petter — Fri, 17 Apr 2015 14:52:32 GMT

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?

Re: How to Display Value during Reload

Fri, 17 Apr 2015 14:55:39 GMT

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.

Re: How to Display Value during Reload

petter — Fri, 17 Apr 2015 15:00:36 GMT

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

Re: How to Display Value during Reload

Fri, 17 Apr 2015 15:09:15 GMT

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

Re: How to Display Value during Reload

Fri, 17 Apr 2015 15:12:54 GMT

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.

Re: How to Display Value during Reload

petter — Fri, 17 Apr 2015 15:15:16 GMT

You can use the expression like this:

=MinString( { 1 <Rooms={'Room 1'} > } 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 ....

Re: How to Display Value during Reload

Fri, 17 Apr 2015 15:16:05 GMT

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,

Re: How to Display Value during Reload

morganaaron — Fri, 17 Apr 2015 15:16:57 GMT

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.

Re: How to Display Value during Reload

Fri, 17 Apr 2015 15:18:39 GMT

Hi Petter,

I applied the expression. This worked perfectly fine.

Thanks,

Re: How to Display Value during Reload

petter — Fri, 17 Apr 2015 15:19:38 GMT

You can actually show all three or any number of statuses in one text box too like this:

=Concat( Rooms & ': ' & Status , Chr(10) )

This will give you a full list of all the statuses

Re: How to Display Value during Reload

Fri, 17 Apr 2015 15:43:11 GMT

Hi Biren,

I like this suggestion of using Chart. We are using the Text Object to change the color of the object based on the status. If status is OK, then do nothing, but if it is Error, then change the color to Red.

Thanks,