Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor II

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

Re: Pivot table dimension calculation

Try this,

AGGR(SUM(Amount), Customer) /Goal


Regards

1 Reply
Partner
Partner

Re: Pivot table dimension calculation

Try this,

AGGR(SUM(Amount), Customer) /Goal


Regards