topic Re: Set Analysis including IF statement for time in QlikView

Set Analysis including IF statement for time

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set Analysis including IF statement for time

vishsaggi — Wed, 17 May 2017 13:19:57 GMT

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

Re: Set Analysis including IF statement for time

Wed, 17 May 2017 13:35:55 GMT

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'?

Re: Set Analysis including IF statement for time

asgardd2 — Wed, 17 May 2017 14:14:45 GMT

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)

Re: Set Analysis including IF statement for time

neelamsaroha157 — Wed, 17 May 2017 14:26:41 GMT

Try this

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