topic Re: Issue with putting a space in an Expression in QlikView

Issue with putting a space in an Expression

rustyfishbones — Wed, 17 Sep 2014 09:53:55 GMT

Hi All,

I have the following Expression

this returns CustomerA30/09/2014

I want it to return CustomerA 30/09/2014, however when I use the following expression, it tells me the expression is OK.

But it returns no result, how can I put a space between Customer and Expiry Date, I am using concat because there could be more than 1 Customer that has a license issue and there for I am using CHR(10) to separate each instance

Re: Issue with putting a space in an Expression

MK_QSL — Wed, 17 Sep 2014 09:59:18 GMT

Can you provide few lines of sample data?

Re: Issue with putting a space in an Expression

rubenmarin — Wed, 17 Sep 2014 10:02:48 GMT

Not sure why it's not working. You tried to set the space after the customer field?

... TODAY())<= 28, [Customer 1] & ' '), [Customer 1] ....

Re: Issue with putting a space in an Expression

tresB — Wed, 17 Sep 2014 10:02:50 GMT

Parenthesis issue.

Put this ' ' along with [Customer 1] that comes in the If part, like: Concat(......(If(........, [Customer 1]& ' '), [Customer 1]

Re: Issue with putting a space in an Expression

rustyfishbones — Wed, 17 Sep 2014 10:02:54 GMT

I am using the expression in an alert, taking the file from Sharepoint.

So it would be like

CompanyA 30/09/2014

CompanyB 30/10/2014

etc....

That's all the data 🙂

Re: Issue with putting a space in an Expression

rustyfishbones — Wed, 17 Sep 2014 10:05:09 GMT

Thanks guys,

so I had it in the wrong place thanks again

Re: Issue with putting a space in an Expression

Anonymous — Wed, 17 Sep 2014 10:10:23 GMT

Hi Alan,

Try this code.

='Concat((AGGR(if(min([License Expiry Date] - Today())<=28,[Customer 1],[Customer 1]) ' & ' ' & aggr(if(min([License Expiry Date] - Today())<= ,[License Expiry Date]),[License Expiry Date])),chr(10))