topic Re: Text Object values that should not change in QlikView

Text Object values that should not change

Anonymous — Tue, 12 Sep 2017 15:19:45 GMT

Hello,

I'm working on a dashboard that contains several sheets.

On the first sheet, the user has access to a filter for "Month/Year" (i.e. Jan 2017 to March 2017). A text object was created to show what timeframe the user has selected. The formula for the text object is shown below:

'Time period chosen: '&Date(Min( MONTHandYEAR), 'MMMM YYYY') &' to '& Date(Max( MONTHandYEAR), 'MMMM YYYY')

I would like to show this text object on each sheet the way it appears on the first sheet whether there are alternate states or not. in the remaining sheets. On the second sheet that is an inherited state, there is a filter that changes the Month/Year values using the formula.

Is there a way in which I can use the formula above and not have the values change regardless of filters or alternate states?

Thanks for your help.

Re: Text Object values that should not change

Anil_Babu_Samineni — Tue, 12 Sep 2017 15:21:50 GMT

Can be done using {1} over set operator

'Time period chosen: '&Date(Min({1} MONTHandYEAR), 'MMMM YYYY') &' to '& Date(Max({1} MONTHandYEAR), 'MMMM YYYY')

Re: Text Object values that should not change

Anonymous — Tue, 12 Sep 2017 15:29:20 GMT

Thanks for the response Anil, but the revised formula does not work. Instead of showing Jan 2017 to March 2017, it is showing the first Month/Year (June 2016) and the last Month/Year (May 2016) available for the user to choose from.

The revised formula disregards the choices made by the user.

Re: Text Object values that should not change

Anonymous — Tue, 12 Sep 2017 15:33:58 GMT

I think I just figured it out. I can create an alternate state just for the text object so whatever I choose to place in the text object will not change --no matter where I choose to use the formula.

Re: Text Object values that should not change

Anil_Babu_Samineni — Tue, 12 Sep 2017 15:39:50 GMT

Yes, Alternate state can achieve. Please close this thread by mark your response as correct.

Note - I don't prefer to use Alternate States many cases until unless needed