Display the variable value in lablel issue

[Anonymous]

HI

I have two variable vstart and vEnd . when i give date range in my chart like below..

Name, sal ,daterange

raju,5000,30

ramu,6000,20

i am expacted o/p ...

What ever given date range in filter level it showing chart like below..

Name, sal, 01-01-2018-01-06-2018(This date fields show by labes)

raju,5000,30

ramu,6000,20

i tried this expression(=Concat(Date($(vStartDate)-($(vEndDate)))))

how to do above thing?

Thanks,

Nani

[shiveshsingh · Accepted solution]

May be this?

let vStartDate = '2018-05-01';

let vEndDate ='2018-06-10';

T:load * inline [Name, sal ,daterange

raju,5000,30

ramu,6000,20]

Label : =(vStartDate) & '-' & (vEndDate)

[Anil_Babu_Samineni]

You can increase your Height of Header from presentation tab? and for that, You can use this?

=Concat(Date($(vStartDate)-$(vEndDate)), '-')

[Anonymous]

Thank you:)

[shiveshsingh]

Glad to know it worked