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

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
limingthefirst
Contributor III
Contributor III

How to calculate the quantity of fixed date range?

Hi all,

now I want to calculate the quantity of fixed date range in Column F,see belowRTX截图未命名1.png

How to write an expression in Qlikview?

This is my expression:


=sum({1<T@Date_num={'>$(=max(T@Date_num)-4)<=$(=max(T@Date_num))'}>}T@Csum*T@Price)

The problem is that all values are the same,
RTX截图未命名.png

Please suggest.

Thanks

Labels (1)
0 Replies