topic Re: Display the variable value in lablel issue in QlikView

Display the variable value in lablel issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 16 Apr 2018 11:06:57 GMT

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 — Mon, 16 Apr 2018 11:25:58 GMT

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

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

Anonymous — Mon, 16 Apr 2018 12:27:24 GMT

Thank you:)

shiveshsingh — Mon, 16 Apr 2018 13:15:54 GMT

Glad to know it worked