Use value in a chart that was calculated in a table

[Moort]

Hi Experts,

I am searching for a solution or at least a workaround for following problem. I created a Table in my Qlik Sense Dashboard where i calculate a value in Column 1 and use this value to calculate another value in column 2. (I need to do this because there are several calculation steps which could not fit into one SQL command within a chart). Now I want to use the calculated value of column 2 to use in a chart, but don't know how/ if this is possible.

Until now I only made it work by: creating said table -> download it as an excel file -> re-import it into qlik via data editor -> use it as a regular data source where I can select its columns.This is not very useful as i dont want to workaround with excel files every time I add data.

My Question is: Can someone tell me how I can use this values from Columns from a table to use as measures for a chart? Or how to "split up" a calculation in several steps?

The Column created looks like that (picture below)Example Picture