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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
rutger_jansen
Contributor III
Contributor III
‎2022-11-29 12:53 PM

Rangesum in Pivot - allow date selection & preserve rangesum

Hi,

I have a pivot with a Rangesum expression. Is it possible to have a dimension in the pivot and use the same field for making selections whilst keeping the same Rangesum  values ?

In the attached sample .qvw, I want to select  June (30/06/2022) and the pivot should show values 350, 750, 1350 for Sum, Rangesum 3m & Rangesum 6m respectively for June 2022 only.

Thanks,

Rutger

 

Labels (1)
Labels
rangesum query.qvw
267 Views
0 Likes
0 Replies