topic Re: Selecting specific fileds from Multibox object in QlikView

Selecting specific fileds from Multibox object

Mon, 04 Jun 2012 08:02:42 GMT

Hi,

I have a field named Period (it is the source of MultiBox object), which has values like Today, Yesterday, Last Day etc.

In the morning, some values, Like Today, should not be available to users because the data for today is still not updated.

When the data of today is being updated, I need that all the values will be available again for the users.

How can i accomplish this?

Thanks,

Guy

Re: Selecting specific fileds from Multibox object

Miguel_Angel_Baeyens — Mon, 04 Jun 2012 08:17:45 GMT

Hi Guy,

You can use a variable in the script so if the data loaded has a date lower than today, the variable gets a 0, otherwise a 1, for example. You have two multiboxes, one with the Today field, the other without it.

Then, in the multibox properties, you can add an expression that shows/hides whole object depending on the variable, in the Layout tab.

Hope that helps.

Miguel