topic Re: Help with if statement or a complete different way to do this. in QlikView

Help with if statement or a complete different way to do this.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I've got a date field where the Manager receives an application, the Manager then has four choices and date field of when manager has done it.

four choices

reject

duplicate

interview

start

So Application1 was received on 1/1/15 and rejected on 2/1/16 so that's 1 days

I can do this bit, the bit I can't do, is if nothings done, I want it to show how many days is app still with manager, I can do that

what I can't do is when I select ID1, I only want it to show 1 not the 260 as well.

Re: Help with if statement or a complete different way to do this.

sunny_talwar — Fri, 07 Oct 2016 13:53:10 GMT

Your attached application is without data. Can you run you application and repost. Also, I am not sure I understand what you are looking to get. Would you be able to try and re-explain this another way?

Re: Help with if statement or a complete different way to do this.

Anil_Babu_Samineni — Fri, 07 Oct 2016 14:04:59 GMT

lakwinder singh wrote:

So Application1 was received on 1/1/15 and rejected on 2/1/16 so that's 1 days

From This how you are calc to get 1 Day. Because there showing 1 Year. I am not sure i understand your Issue to get feasible values

Re: Help with if statement or a complete different way to do this.

Anonymous — Fri, 07 Oct 2016 14:05:54 GMT

Typo for description

Re: Help with if statement or a complete different way to do this.

Anonymous — Fri, 07 Oct 2016 14:35:28 GMT

Ok, the test app is up.

I want to show how many days did it take the manager to allocate the application as Rejected, duplicate, interview or start, or if nothing is picked, then today - with manager.

There can only be one text box with a number in it, at the moment im getting the correct days for Rejected, duplicate, interview or start, but its also showing time with manager, I only want to see one populated text box.

Re: Help with if statement or a complete different way to do this.

Anonymous — Fri, 07 Oct 2016 14:35:47 GMT

Ok, the test app is up.

I want to show how many days did it take the manager to allocate the application as Rejected, duplicate, interview or start, or if nothing is picked, then today - with manager.

Re: Help with if statement or a complete different way to do this.

Anonymous — Fri, 07 Oct 2016 14:35:54 GMT

Ok, the test app is up.

I want to show how many days did it take the manager to allocate the application as Rejected, duplicate, interview or start, or if nothing is picked, then today - with manager.

Re: Help with if statement or a complete different way to do this.

sunny_talwar — Fri, 07 Oct 2016 15:50:37 GMT

Can you check and attached and see if this is what you wanted?

Re: Help with if statement or a complete different way to do this.

Anonymous — Fri, 07 Oct 2016 16:07:12 GMT

No. I want, when you select ID2, all five text boxes to remain, but only show the number 2 for the two days it took, I need some sort of if statement to not show the 279 which is still calculating the start date to today, the only time I want to see the 279 number is if no dates have been filled in the Rejected, Duplicate, Interview, start fields

Re: Help with if statement or a complete different way to do this.

sunny_talwar — Fri, 07 Oct 2016 16:09:33 GMT

Try now

Re: Help with if statement or a complete different way to do this.

Anonymous — Fri, 07 Oct 2016 16:14:36 GMT

Mate you are a star...............................................

Re: Help with if statement or a complete different way to do this.

Anonymous — Fri, 07 Oct 2016 16:16:05 GMT

There might be another little bit to this, but I may be able to figure it out using your technique on Monday. Thanks. This tracker model will blow the clients socks off lol