Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
did u try with
=Chr(13)'& ur date field '&
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.
You can create the custom pop up labels
May be like attached?
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))
hi tresesco , exactly what i need !! great answer - THANKS .
HI Kush - thanks !
Hi again ,do you have any idea why it is not work on LineChar ? ( on BarChart ITS ok ) .
Hi again ,do you have any idea why it is not work on LineChar ? ( on BarChart ITS ok ) .