Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

variation %

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 :

Capture.PNG

the excel extract would be like this :

Capture.PNG

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

2 Replies
swuehl
MVP
MVP

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
Specialist
Specialist

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

Capture.JPG

Regards,

Mayank