topic Re: IF Condition - Like Operator in QlikView

IF Condition - Like Operator

nihhalmca — Thu, 04 Jun 2015 06:05:30 GMT

Hi All,

Need your help.

I want to implement logic at back end. for example. Field name is Gaap/Non-Gaap it has values like

Gaap/Non-Gaap

Gaapxyz

Gaap 123

up to 100 values

Non-Gaapxyz

Non-Gaap 123

Up to 150 values

xyz

123

And my requirement is i want to make these many values as 4 values

value 1: where ever 'Gaap' text is there consider as Gaap

value 2: where ever 'Non-Gaap' text is there consider as Non-Gaap

value 3: xyz

value 4: 123

Result should be

Gaap/Non-Gaap

Gaap

Non-Gaap

xyz

123

For all i know, have to use LIKE operator (WildMatch) in IF condition.

Regards,

Nihhal.

Re: IF Condition - Like Operator

jagan — Thu, 04 Jun 2015 06:11:29 GMT

Hi Nihhal,

Try like this

LOAD

If(Pick(WildMatch(FieldName, '*xyz*', '*123*', '*Non-Gaap*', '*Gaap*', '*'), 'xyz', '123', 'Non-Gaap', 'Gaap', FieldName) AS NewFieldName

FROM DataSource;

Regards,

Jagan.

Re: IF Condition - Like Operator

MayilVahanan — Thu, 04 Jun 2015 06:33:07 GMT

Try like this

Load *, Pick(WildMatch(Gaaps, 'xyz', '123', '*Non-Gaap*', '*Gaap*', '*'), 'xyz', '123', 'Non-Gaap', 'Gaap', Gaaps) AS NewGaaps;

Load * Inline

[

Gaaps

Non-Gaapxyz

Non-Gaap 123

Gaapxyz

Gaap 123

xyz

123

sdfs

];

Re: IF Condition - Like Operator

nihhalmca — Thu, 04 Jun 2015 07:15:03 GMT

Thanks for reply ramasamy.

It is working fine, however 'Preceding load is not require here.

Thank you.

Nihhal.

Re: IF Condition - Like Operator

nihhalmca — Thu, 04 Jun 2015 07:17:15 GMT

Thanks for reply Jagan.

It is not working fine, due to IF condition.

Thank you.

Nihhal.

Re: IF Condition - Like Operator

MayilVahanan — Thu, 04 Jun 2015 07:18:09 GMT

Hi Nihal,

For understanding, used like that.

Re: IF Condition - Like Operator

jagan — Thu, 04 Jun 2015 07:21:51 GMT

Yes by mistake I typed If in the expression, otherwise it works.

Regards,

Jagan.

Re: IF Condition - Like Operator

nihhalmca — Thu, 04 Jun 2015 07:50:10 GMT

Ok ramasamy.