topic Re: variation % in QlikView

variation %

master_student — Tue, 03 Oct 2017 08:58:43 GMT

Hello Guys,

I need your help.

I have a graph that i would like to export it to excel until now everything is okay. here is the graph :

the excel extract would be like this :

I would like to add a new field only whene i export to excel, the new field is the variation : column 1 /column2 *100

is that feasible?

Thanks

swuehl — Tue, 03 Oct 2017 09:02:29 GMT

It might be feasible if you create a third expression

=Column(1) / Column(2) *100

and remove all the display options on expression tab to show in the line chart, so it will only show up in a table chart.

mayankraoka — Tue, 03 Oct 2017 09:09:34 GMT

It is possible add the third expression and uncheck all the expression.While export you will see the new column.

Regards,

Mayank