Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
jtrillori
Contributor
Contributor

Help with set analysis expression

morning,

how can i convert this expression

if(fecha < fecha1 and fecha>(fecha1-365), importe)

in a set analysis expression?

thanks and regards

1 Solution

Accepted Solutions
Gysbert_Wassenaar

try sum({<fecha={"=fecha<fecha1 and fecha>(fecha1-365)"}>}importe)


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
er_mohit
Master II
Master II

SUM({<fecha={'>(fecha1-365)<fecha1'} >} importe)



jtrillori
Contributor
Contributor
Author

sorry the entire expression is like that

sum(if(fecha < fecha1 and fecha>(fecha1-365), importe))

thanks

Gysbert_Wassenaar

try sum({<fecha={"=fecha<fecha1 and fecha>(fecha1-365)"}>}importe)


talk is cheap, supply exceeds demand
jtrillori
Contributor
Contributor
Author

works nice

thanks a lot