topic Re: help in QlikView

help

vinod2086 — Fri, 05 Feb 2016 07:28:21 GMT

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.

Re: help

MK_QSL — Fri, 05 Feb 2016 07:32:34 GMT

Use below in script

Load

status,

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

From Tablename;

Re: help

vinod2086 — Fri, 05 Feb 2016 07:35:30 GMT

Hi Manish,

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

Re: help

sorrakis01 — Fri, 05 Feb 2016 07:38:34 GMT

Hi,

Look again Manish expresion. Works well.

Regards,

Re: help

vinod2086 — Fri, 05 Feb 2016 07:48:49 GMT

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

Re: help

sunny_talwar — Fri, 05 Feb 2016 07:50:24 GMT

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);

Re: help

HirisH_V7 — Fri, 05 Feb 2016 07:55:30 GMT

Hi,

You can create in your script like this ,

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

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

HTH,

Hirish

Re: help

jagan — Fri, 05 Feb 2016 07:57:33 GMT

Hi,

Try like this in script;

Load

status,

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

From DataSource;

Regards,

jagan.

Re: help

sorrakis01 — Fri, 05 Feb 2016 07:59:46 GMT

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,

Re: help

vinod2086 — Fri, 05 Feb 2016 08:03:38 GMT

hey am sorry manish its working fine..

Thank you so much

Re: help

vinod2086 — Fri, 05 Feb 2016 12:49:11 GMT

Hi Manish,

i have one more situation PFB

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

for complete cases we had done and pending cases i want to display NEW instead of standard . both conditions should be at single place any new idea.

Re: help

sunny_talwar — Fri, 05 Feb 2016 12:53:39 GMT

‌try this:

If(status = 'complete','Enterprise',

If(status = 'pending', 'NEW', type)) as type

Re: help

sorrakis01 — Fri, 05 Feb 2016 12:54:26 GMT

Hi,

If(Status='complete','Standard',

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

regards

Re: help

vinod2086 — Fri, 05 Feb 2016 13:22:53 GMT

Thanks sunny..