topic Re: Make New Fields from Chart in QlikView

Make New Fields from Chart

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

Hi, everone.

I want to ask something, is it possible to make a new field from a chart, where the chart I'm using to make a new field is the result of calculation from another chart ?

The charts I need to make fields :

Those 2 charts above are the result of calculation from this chart :

If it's possible, can anyone guide me ?

Thanks in advance.

- Kevin

Re: Make New Fields from Chart

sasikanth — Thu, 05 Jul 2018 05:39:46 GMT

HI,

What Filed do you want to derive and why cant we derive it from main chart ??

Re: Make New Fields from Chart

rmdnkevin — Thu, 05 Jul 2018 05:58:01 GMT

New fields that I need are Simulation Clicked, Simulation Reported, and Report-to-Clicked Ratio.

Those 2 new charts are the results of calculation from main chart, and I need the values from the 2 new charts to make a new average calculation

Re: Make New Fields from Chart

sasikanth — Thu, 05 Jul 2018 06:13:09 GMT

Please do provide logic for Simulation Clicked, Simulation Reported, and Report-to-Clicked Ratio

Re: Make New Fields from Chart

rmdnkevin — Thu, 05 Jul 2018 06:28:54 GMT

Simulation Clicked = (Clicked Link + Submitted Data) / (Email Sent + Email Opened + Clicked Link + Submitted Data)

Simulation Reported = Email Reported / (Email Sent + Email Opened + Clicked Link + Submitted Data)

Report-to-Clicked Ratio = Email Reported / (Clicked Link + Submitted Data)

Re: Make New Fields from Chart

sasikanth — Thu, 05 Jul 2018 07:05:48 GMT

Did you try to use these expressions directly to derive New Average expression??

OR you can also create variable and use them in new expression

Let me know if any

Thanks,

Re: Make New Fields from Chart

rmdnkevin — Thu, 05 Jul 2018 08:26:51 GMT

Here I attach the datas.

Need to count the average Simulation Clicked from Click and Report Rates chart, and average Report-to-Click Ratio in a new box.

I think from those calculations need its own field such Simulation Clicked field and Report-to-Click Ratio field, doesn't it ?