Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
New Contributor III

Calculate measure with measure name from Excel template

hi Experts,

i would like to make P&L app in the Qlik sense Feb 2019.  According to below excel template, in pivot table,

row is from header text and column from measure. eg. in table, if the header text is GS, get measure name is Gross Sales amount, in the database there is field called Gross Sales. 

it can accomplish with several if statement, however i would like to make it automatically ways.  if user want to add one row in existing table like want to see profit, he just put header text and measure name in the excel template and load data.  Thanks in advance, experts.