topic Re: WildMatch expression in Text Object, wrong syntax or not possible? in QlikView

WildMatch expression in Text Object, wrong syntax or not possible?

bullish35 — Thu, 17 Jan 2013 18:52:43 GMT

Hello,

IF(WildMatch([FieldA], '*Exit*'),

THEN this expression to create the field to use: ['Text[FieldValue]Text'],

ELSE this expression to create the field to use: ['Text[FieldValue-1]Text']

The expression I'm using:

(wildmatch(PRJ_Current, '*Exit*'), 'PRJ_P'&[PRJ_Current Phase ID]&' Phase Exit Date Target', 'PRJ_P'&([PRJ_Current Phase ID]-1)&' Phase Entry Date Target')

Thanks in advance!

Ellen

Re: WildMatch expression in Text Object, wrong syntax or not possible?

Nicole-Smith — Thu, 17 Jan 2013 19:11:56 GMT

Try:

(PRJ_Current like '*Exit*', 'PRJ_P'&[PRJ_Current Phase ID]&' Phase Exit Date Target', 'PRJ_P'&([PRJ_Current Phase ID]-1)&' Phase Entry Date Target')

Re: WildMatch expression in Text Object, wrong syntax or not possible?

bullish35 — Thu, 17 Jan 2013 19:26:56 GMT

Getting close!

This returns the text value: "PRJ_P1 Phase Entry Target". However, this is actually the name of a field, [PRJ_P1 Phase Entry Target], and I want the field value to be presented vs. the name of the field in text. I tried bracketing the whole THEN and ELSE statements, but that doesn't seem to work.

This is what I had last:

(PRJ_Current like '*Exit*', ['PRJ_P'&[PRJ_Current Phase ID]&' Phase Exit Date Target'], ['PRJ_P'&([PRJ_Current Phase ID]-1)&' Phase Entry Date Target'])

Thank you Nicole!

Re: WildMatch expression in Text Object, wrong syntax or not possible?

Nicole-Smith — Thu, 17 Jan 2013 20:25:44 GMT

I'm thinking that dollar sign expansion needs to be used here somehow. I will need to play around with it some to get it to work.

Re: WildMatch expression in Text Object, wrong syntax or not possible?

Nicole-Smith — Thu, 17 Jan 2013 20:28:19 GMT

I spoke too soon. This should work:

(PRJ_Current like '*Exit*', $(='[PRJ_P'&[PRJ_Current Phase ID]&' Phase Exit Date Target]'), $(='[PRJ_P'&([PRJ_Current Phase ID]-1)&' Phase Entry Date Target]'))

Re: WildMatch expression in Text Object, wrong syntax or not possible?

shree909 — Thu, 17 Jan 2013 20:42:16 GMT

Hi,

can u try like this.

(PRJ_Current like '*Exit*', ' ['PRJ_P'&[PRJ_Current Phase ID]&' Phase Exit Date Target']',

'['PRJ_P'&([PRJ_Current Phase ID]-1)&' Phase Entry Date Target']')

may be its not underatand the code for condition ---' ['PRJ_P'&[PRJ_Current Phase ID]&' Phase Exit Date Target']',--

can u try that expression in text box, if that works create a variable and assign to it...

Re: WildMatch expression in Text Object, wrong syntax or not possible?

sebastiandperei — Thu, 17 Jan 2013 21:01:47 GMT

Hi Ellen.

In a Text Box, you need to aggregate or filter the fields you are using.

If the field FieldA has more than one value (I think this is true), the WildMatch function "doesn't know" which one get to return the result.

If you want to show in a Text Box if there is a string in any value of a field, you coud use:

If ( Count ({<FieldA={"*Exit*"}>} FieldA) >1, 'Yes, the field has Exit string', 'No, the field hasn't Exit string')

It will work in a TextBox

Re: WildMatch expression in Text Object, wrong syntax or not possible?

bullish35 — Thu, 17 Jan 2013 22:12:11 GMT

That did it! Thank you so much.

Re: WildMatch expression in Text Object, wrong syntax or not possible?

bullish35 — Thu, 17 Jan 2013 22:14:52 GMT

Thank you Sebastian. The field only has one value but thank you for your responding!

Re: WildMatch expression in Text Object, wrong syntax or not possible?

bullish35 — Thu, 17 Jan 2013 22:15:30 GMT

Thank you for responding!