Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to use a calculation of a delay in another chart :
I did in an array this expression which is the delay between Date_1er_Ttment and now.
Avg( {<[Type de Contact] -= {'P52'}>}
NetWorkDays(
Date_1er_Ttment,vToday))
And I want to re use this expression already calculated in another chart, to have the delay superior than 20 days for example.
I tried something like this (recalculate the delay)
if( NetWorkDays(Date_1er_Ttment,vToday)>20,
Count({<[Type de Contact] -= {'P52''}>} Date_1er_Ttment))
But it doesn't work, is there a way I can re use my delay already calculated in another chart ?
Thank you
Probably. It should be possible to put the expression in a variable and reuse it that way in other charts. But I have no idea what dimensions you use in the charts. Different dimensions will mean different results. Perhaps you can post a small qlikview document that shows what you're trying to do.
I'm just trying to make a conditon with the delay.
I have 2 dates, and if the delay is greater than 20 for exemple, I want to count the line.
I tried this :
if( NetWorkDays(Date_1er_Ttment,vToday) > 100, Count(Date_1er_Ttment))
But it doesnt work, nothing appear, and I have no error.
Thank you