Set Analysis including IF statement for time

[#1]

Hi,

I have an expression in my pivot table that I am trying to display in a text box

if([Team Name]='Team A ',if(WildMatch(VEasternHH,'*18*','*19*'),'Closed','Open'))

The expression looks at the team name and if the team name is equal to a particular team it then looks at the current hour (VEasternHH) and identifies whether open or closed.

This works perfectly in a pivot table but I am struggling to get it to display in a text box for an individual team.

I think it needs to be incorporated into set analysis but can't get it right.

Thank you in advance

[vishsaggi]

What is happening when you trying to use this IF in your text box, can you post your sample app to work on?

[#3]

Hi Vishwarath, I don't have a sample app to upload a t the moment but when I try it I just get a '-'

Do I need to use set analysis as in my data set I have 25 different teams within the Column 'Team Name'?

[asgardd2]

Hello!

I created a test application for you. Please, show, what you want to see in the textbox.

Is textbox working correctly, then you select "Team 1"?

P.S. Function now() not update automatically, updated only after any selection in report. (if you use ajax browser)

[neelamsaroha157]

Try this

Only({<[Team Name] = {'Team 1'}>}if(WildMatch(hour(now()),'1*'), 'Open','Closed'))