Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

Issue with putting a space in an Expression

Hi All,

I have the following Expression

2014-09-17_1049.png

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

2014-09-17_1050.png

1 Solution

Accepted Solutions
rubenmarin

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

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

View solution in original post

6 Replies
MK_QSL
MVP
MVP

Can you provide few lines of sample data?

rubenmarin

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

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

View solution in original post

tresesco
MVP
MVP

Parenthesis issue.

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

rustyfishbones
Master II
Master II
Author

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 🙂

rustyfishbones
Master II
Master II
Author

Thanks guys,

so I had it in the wrong place thanks again

dhirajkumar
Creator
Creator

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))