Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
jtrillori
Partner - Contributor
Partner - 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
Partner - Contributor
Partner - 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
Partner - Contributor
Partner - Contributor
Author

works nice

thanks a lot