topic Re: If statement in QlikView

If statement

bimanbeginner — Wed, 12 Jul 2017 08:06:20 GMT

Hi There.

Im trying to write an if statement that doesnt seem to be working

I have a field Name

I want to create a new field which defines these Names.

in this field I want Closed,Open and All

I have tried below:

if( Name='Closed','Closed',

If(Name<>'Closed','Active')) as FieldName

This works to get my closed and active steps, how do i get all in the same statement?

FYI :I have many names in this field

Thank You

Re: If statement

MK_QSL — Wed, 12 Jul 2017 08:10:17 GMT

As I understood from your post,

Any name having 'Closed' word, you want to declare as Closed.

What are the criteria for All and Active?

Re: If statement

Anil_Babu_Samineni — Wed, 12 Jul 2017 08:10:44 GMT

May be this?

If(Name = 'Closed', 'Closed', If(Name = 'Open', 'Open', 'All')) as FieldName

Re: If statement

ahaahaaha — Wed, 12 Jul 2017 08:12:26 GMT

Try

if( Name='Closed','Closed','Active') as FieldName

Re: If statement

bimanbeginner — Wed, 12 Jul 2017 08:13:46 GMT

Everything with closed will be closed everything else is still active.

but the user must be able to distinguish between closed active and both by selecting one in a list box...

Re: If statement

bimanbeginner — Wed, 12 Jul 2017 08:16:19 GMT

There is no field defining open names... but the logic is that if it is not closed... then it is open.. or active...

Re: If statement

bimanbeginner — Wed, 12 Jul 2017 08:19:45 GMT

Hi Andrey... what about all though?

Re: If statement

Anil_Babu_Samineni — Wed, 12 Jul 2017 08:22:08 GMT

If you don't have field name called Name. Then how you are calculating? May be check one funny solution with ValueList() ?? If not i may not understand the rek

FYI - My expression may give make sense if you have field called Name

Re: If statement

bimanbeginner — Wed, 12 Jul 2017 08:28:33 GMT

Sorry i think i havent explained correctly.

The field Name does exist, but there is a name called closed which identifies all closed items all other items will be open hence me using <> to closed in my initial expression... There is no name = 'Open' the logic is that if it is not closed then it is open

Re: If statement

PrashantSangle — Wed, 12 Jul 2017 08:35:42 GMT

Can be more specific. Better with example.

Regards

Re: If statement

Anil_Babu_Samineni — Wed, 12 Jul 2017 08:44:44 GMT

Can you create one inline and explain the result set as you required. That may helpful to trigger

Re: If statement

tresB — Wed, 12 Jul 2017 08:46:12 GMT

It seems that you need something like generic field.

If so, try like:

t1:

Load * Inline [

Status

Closed

ABC

BCD

Not Closed

Opennn

];

t2:

Load

'All' as GenericStatus,

Status

Resident t1;

t2:

Load

Status as GenericStatus,

Status

Resident t1 where Status='Closed';

Load

'Open' as GenericStatus,

Status

Resident t1 where Status<>'Closed';

Re: If statement

bimanbeginner — Wed, 12 Jul 2017 08:55:45 GMT

Thank You, an alternative to this is to create 3 buttons with actions on them to select those fields

Re: If statement

tresB — Wed, 12 Jul 2017 09:07:19 GMT

For this specific case, since 'Open' and 'Closed' are mutually exclusive, you can reduce one load and simplify like:

t1:

Load * Inline [

    Status

    Closed

    ABC

    BCD

    Not Closed

    Opennn

];

t2:

Load

      'All' as GenericStatus,

      Status

Resident t1;

t2:

Load

      If(Status='Closed', Status, 'Open') as GenericStatus,

      Status

Resident t1;