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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
FCanseco
Contributor
Contributor

Rangesum issue

Hi,

I'm using a Pivot Table Chart to accumulate a field value.

 

I1.jpg

ACTUAL field is calculate:

RangeSum(below(ACTUAL), $(vActual))

vActual field is the value of vActual variable:

$(vActual)

In this case the report works, but I must to transforn the report in Chart Straight table to be able to create an Excel using only some fields to send this Excel in Npriting.

 

When I convert to Chart Straigt table, ACTUAL field doesn't calculate correctly.

I2.jpg

 

Any idea?

Thanks in advance.

@sunny_talwar 

 

 

0 Replies