Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

helen_pip
Contributor II

Between Function equivalent

Hello

I was wondering if someone oculd help me write a function which may otherwise use the function between

I want to show the number of people with a waiting time between 60 and 120

I.e. If([Waiting_Time] between 60 and 120, 1,0) scenario

Can anyone help me?

Kind Regards

Helen

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Between Function equivalent

Unfortunately QV has no between function. You'll have to use if(Waiting_Time>=60 and Waiting_Time<=120,1,0)


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: Between Function equivalent

Unfortunately QV has no between function. You'll have to use if(Waiting_Time>=60 and Waiting_Time<=120,1,0)


talk is cheap, supply exceeds demand

Re: Between Function equivalent

Hi,

You can write this script like

Before

If([Waiting_Time] between 60 and 120, 1,0)

similar to

If([Waiting_Time] >=60 and [Waiting_Time] <=120, 1,0)

HTH

Regards,

Anand

helen_pip
Contributor II

Re: Between Function equivalent

Hello

Thank you!  It works.  I should of realised what I should write it like that. 

Thanks alot

Helen

helen_pip
Contributor II

Re: Between Function equivalent

Hello,

Thank you for this.  It works

Thanks

Helen

Community Browser