topic Re: Issue with spaces on webview in QlikView

Issue with spaces on webview

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to show spaces before my second and third values in my dimension.

So I gave my expression as

=if(match(%ESFilters2,'Initial Issuances [#]'),' Initial Issuances [#]',

if(match(%ESFilters2,'Repeat Issuances [#]'),' Repeat Issuances [#]',%ESFilters2))

It works fine on my desktop but doesn't work on webview. Can anyone provide me any suggestions on this.

Attached is a screenshot.

Regards,

Aditya

robert_mika — Wed, 09 Mar 2016 00:51:05 GMT

Web probably will trim all spaces.

Try to add ASCI character

Chr(32)

=if(match(%ESFilters2,'Initial Issuances [#]'),Chr(32)&' Initial Issuances [#]'........

Feeling Qlikngry?

Wed, 09 Mar 2016 01:52:55 GMT

Hi Robert,

Chr(32) also didn't work on web view and I also tried chr(9) as well, that too didn't work.

jagan — Wed, 09 Mar 2016 02:10:05 GMT

HI,

I think it will remove the blank spaces in web view, instead you can try by using .... (Pull stops).

Regards,

jagan.

Wed, 09 Mar 2016 02:15:28 GMT

May be its not working on the web view mode. Did you try on access point ?

Wed, 09 Mar 2016 02:17:59 GMT

No, But I'll try that first thing in the morning.

settu_periasamy — Wed, 09 Mar 2016 02:18:35 GMT

Hi,

I think it is working in webview.

May be try like..

=if(match(%ESFilters2,'Initial Issuances [#]'),Repeat(chr(160),5)&'Initial Issuances [#]',

if(match(%ESFilters2,'Repeat Issuances [#]'),Repeat(chr(160),5)&'Repeat Issuances [#]',%ESFilters2))

Wed, 09 Mar 2016 02:21:50 GMT

Hi Settu. It worked, Thanks..