Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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