How to show on pop-up lable the current date of calculate-dimension with dates interval ?

[yanivvl0]

hi everybody,

Further to previous discussion, it can be seen in https://community.qlik.com/thread/208591?sr=inbox ,

i need to show on pop-up lable the Date of measurement for each project. because each project starts in different date and and the calculate-dimension Presents the interval of day between the start date and the Date of measurement It's a bit problematic ,

here is the wanted result where the start date of project 102 is 1/1/2015 :

thanks.

[Chanty4u]

did u try with

=Chr(13)'& ur date field '&

[yanivvl0]

hi Chanty , its not a display problem.

"Date" is not a measure or a dimension , we have to bring it somehow - and this is the tricky part of the question .

all the issu began in the previous discussion.  shortly :

i have projects dimension and a calculated-dimension interval  : floor(ProjectDate-RegistrationDate) and measure count(RegistrationId)  - thats what u see in the Higher image. what i dont have is the date : ProjectDate+interval days.  - thats what i need to show.

if some things are not clear i can explain more, thanks.

[Kushal_Chawda]

You can create the custom pop up labels

Define Your Pop-Ups

[tresesco · Accepted solution]

May be like attached?

[Kushal_Chawda]

In your case custom pop up expression would be

='Projects=' & Project & chr(10) &

  'Interval=' & floor(ProjectDate-RegistrationDate) & chr(10) &

  'Count =' & count(RegistrationId) & chr(10) &

  'Date =' & Date(ProjectDate+floor(ProjectDate-RegistrationDate))

[yanivvl0]

hi tresesco , exactly what i need !!   great answer - THANKS .

[yanivvl0]

HI  Kush  - thanks !

[yanivvl0]

Hi again ,do you have any idea why it is not work on LineChar ?   ( on BarChart ITS ok ) .

[yanivvl0]

Hi again ,do you have any idea why it is not work on LineChar ?   ( on BarChart ITS ok ) .