topic Re: Use calculated expression in another chart in QlikView

Use calculated expression in another chart

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Use calculated expression in another chart

Gysbert_Wassenaar — Thu, 30 Jun 2016 16:21:21 GMT

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.

Re: Use calculated expression in another chart

Fri, 01 Jul 2016 09:17:37 GMT

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