Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use calculated expression in another chart

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

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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