topic naming field values in QlikView

naming field values

Anonymous — Thu, 03 Sep 2015 10:15:47 GMT

Hi,

There's a field 'Brand' in my application. One of the values in the field is '+ Active'.

I have noticed that the sign '+' causes dashboard bugs sometimes.

For instance, the dashboard is published on ther server, and I do the following:

1) I select 10 brands including '+ Active'.

2) I click the button print report which activates the action 'Print'.

3) Then the field 'Brand' is automatically cleared. This is a bug.

Actually the bug doesn't happen if the brand '+ Active' is not selected among other brands.

Could you advaise anything?

Thank you in advance,

Larisa

Re: naming field values

marcus_sommer — Thu, 03 Sep 2015 11:16:59 GMT

I think the reason is that this + sign will be somehow interpretet as calculation and leads to NULL and this leads to the deselection - a clear selection call for field is the same like a selection with = null(). I agree that's looked like a bug and I haven't a solution but you could try to bypass it with adding from additionally quotes to this value or to add before the + sign a space char - chr(32) - or a zero-space char like chr(8203) or similar chars to prevent a calculation.

Useful might be also to try it with a dual-field for this - I mean a result like:

dual('+ Active', 'Active') or more practically: dual(Brand, Autonumber(Brand))

Hope this is helpful.

- Marcus

Re: naming field values

Anonymous — Thu, 03 Sep 2015 11:29:17 GMT

Thanks Markus,

if I try in script:

load DUAL dual(Brand, Autonumber(Brand)) as Brand

Will the program autonumber distinct brands only?

If not how can I autonumber distinct brands?

Re: naming field values

PrashantSangle — Thu, 03 Sep 2015 11:32:29 GMT

Hi,

Use purgeChar() to clean data

PurgeChar(fieldName,'+')

Regards

Re: naming field values

marcus_sommer — Thu, 03 Sep 2015 11:35:32 GMT

Autonumber() is distinct. Here you will see some examples: Counters in the Load.

- Marcus

Re: naming field values

Anonymous — Thu, 03 Sep 2015 12:29:54 GMT

Thanks a lot, Marcus,

a zero-space char like chr(8203) before the plus-sign is a very good solution.

Larisa