Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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