topic Re: Use output from One Chart as Input to Another in QlikView

Use output from One Chart as Input to Another

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a straight table(Sample attached) where i am calculating value of a column(Averted Cost) using the below formula:

REMDAYS*SUM(CX_MINUTES* CX_RATE)

the field REMDAYS is a number which is calculated using a Load statement in the editor(This number is the difference between 2 dates and varies per account).

I want to create another straight table, which will calculate the Sum of Averted Loss on a monthly basis. How can i do that?

I am able to get the SUM of Customer Cost as this is taken from the DB directly, but as the Averted Cost is calculated using a function, how can we use that?

Thanks

Taher

Re: Use output from One Chart as Input to Another

vishsaggi — Mon, 11 Jun 2018 16:21:20 GMT

Could not find any sample attached. Can you re upload please?

Re: Use output from One Chart as Input to Another

rubenmarin — Mon, 11 Jun 2018 16:22:34 GMT

Hi Taher, to do a table eith month as dimension (and no customer) you can add an aggr() to calculate the value per customer, and sum the value of all customers:

Sum(Aggr(REMDAYS*SUM(CX_MINUTES* CX_RATE), MonthField, CustomerField))

Re: Use output from One Chart as Input to Another

Anonymous — Mon, 11 Jun 2018 16:37:28 GMT

He Vishwarath,

I attached the image instead.

Re: Use output from One Chart as Input to Another

Anonymous — Mon, 11 Jun 2018 16:37:46 GMT

Hi Ruben,

This worked. Thanks a lot.

Taher