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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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

0 Replies