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: 
paulyeo11
Master
Master

How to add few blank space between YYYY and SOURCE ?

Hi All

Below expression :-

='P&L Report (S$K)' & Chr(10)  & date(date#(Year(Today())-3,'YYYY'),'YYYY')   & SOURCE & '

Will display as :-

P&L Report (S$K)2014TDSS

i wish it display as :-

P&L Report (S$K)  2014  TDSS

Paul

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

try this?

= 'P&L Report (S$K)' & Chr(32)  & date(date#(Year(Today())-3,'YYYY'),'YYYY') &  Chr(32) & SOURCE

View solution in original post

4 Replies
jwjackso
Specialist III
Specialist III

I would think just adding spaces in the string would work:

='P&L Report (S$K) '& date(date#(Year(Today())-3,'YYYY'),'YYYY')&' 'SOURCE


Why are you using the Chr(10) and why is there a single quote at the end?

vishsaggi
Champion III
Champion III

try this?

= 'P&L Report (S$K)' & Chr(32)  & date(date#(Year(Today())-3,'YYYY'),'YYYY') &  Chr(32) & SOURCE

View solution in original post

paulyeo11
Master
Master
Author

Hi Vish

Thank you it work fine.

Paul

vishsaggi
Champion III
Champion III

Yes it does work. Just one & is missing in your expression just before SOURCE.

= 'P&L Report (S$K) '& date(date#(Year(Today())-3,'YYYY'),'YYYY') & ' ' & SOURCE