help

[vinod2086]

Hi Team ,

please find below  in that i have 2 columns status and type. my issue is if status is completed then type should be "Enterprise" how to change standard to enterprise

status		type
complete		standard
complete		standard
complete		standard
complete		Enterprise
complete		Enterprise
complete		Enterprise
complete		standard

Thanks in Advance.

[MK_QSL · Accepted solution]

Use below in script

Load

     status,

     If(status = 'complete', 'Enterprise', type) as type

From Tablename;

[vinod2086]

Hi Manish,

My question is for all completed status , type should be Enterprise not standard.

[sorrakis01]

Hi,

Look again Manish expresion. Works well.

Regards,

[vinod2086]

Hi Jordi,

status		type
complete		standard
complete		standard
complete		standard
complete		Enterprise
complete		Enterprise
complete		Enterprise
complete		standard

please see above file in that type is displaying "standard" and "enterprise" but my situation is i don't want to display "standard" for all status completed cases type need to display "Enterprise"

please help

[sunny_talwar]

That is exactly what is going to happen once you run Manish's if statement in your load statement.

Sample attached:

Table:

LOAD RowNo() as UI,

  status,

     If(status = 'complete', 'Enterprise', type) as type

FROM

[https://community.qlik.com/thread/204340]

(html, codepage is 1252, embedded labels, table is @1);

[HirisH_V7]

Hi,

You can create in your script like this ,

If(Status='Complete','Standard','Enterprise') as Type

or

If(Status='Complete','Standard',Type) as Type

HTH,

Hirish

[jagan]

Hi,

Try like this in script;

Load

     status,

     If(MixMatch(Trim(status), 'complete', 'Enterprise', type) as type

From DataSource;

Regards,

jagan.

[sorrakis01]

Hi,

Yes exactly and repeat, Manish expresion is the solution to your problem.

Always of Status be 'Complete' type will be 'Enterprise' and if you one another one Status will be another Type...

Regards,

[vinod2086]

hey am sorry manish its working fine..

Thank you so much