Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

Pivot table dimension calculation

Hi guys,

In my qlik sense pivot table, I got two rows:

Capture.PNG

The second row should be sales_amount/goal. So I put my function as: SUM(Amount)/Goal. The expression shows OK, but after applied, it becomes invalid dimension:

Capture.PNG

Is it because can't do calculation with dimension? What should I do if I still need to put Goal% into dimension?

Thanks in advance!

1 Solution

Accepted Solutions
german24
New Contributor III

Re: Pivot table dimension calculation

Try this,

AGGR(SUM(Amount), Customer) /Goal


Regards

1 Reply
german24
New Contributor III

Re: Pivot table dimension calculation

Try this,

AGGR(SUM(Amount), Customer) /Goal


Regards

Community Browser