Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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