topic Re: How to show on pop-up lable the current date of calculate-dimension with dates interval ? in QlikView

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

yanivvl0 — Sun, 20 Mar 2016 12:55:55 GMT

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.

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

Chanty4u — Sun, 20 Mar 2016 13:06:37 GMT

did u try with

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

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

yanivvl0 — Mon, 21 Mar 2016 06:08:57 GMT

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.

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

Kushal_Chawda — Mon, 21 Mar 2016 06:20:32 GMT

You can create the custom pop up labels

Define Your Pop-Ups

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

tresB — Mon, 21 Mar 2016 06:23:17 GMT

May be like attached?

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

Kushal_Chawda — Mon, 21 Mar 2016 06:24:47 GMT

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))

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

yanivvl0 — Mon, 21 Mar 2016 07:56:02 GMT

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

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

yanivvl0 — Mon, 21 Mar 2016 07:57:19 GMT

HI Kush - thanks !

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

yanivvl0 — Tue, 22 Mar 2016 09:56:25 GMT

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

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

yanivvl0 — Tue, 22 Mar 2016 09:56:40 GMT

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