New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Help with Set analysis between 2 numbers

Hi,

I'm trying to write an expression with set analysis that will  sum the number of Sales (IsSale) if the Sale age is between 0 and 30

Here is what I have so far but it isn't working out

Sum({\$<SaleAge={>=(0)<=(30)>} IsSale)

What am I doing wrong, what is the correct syntax?

Thanks for the help.

Tags (2)
3 Replies
Highlighted
MVP

Re: Help with Set analysis between 2 numbers

Sum({\$<SaleAge={">=0<=30"}>} IsSale)

Valued Contributor II

Re: Help with Set analysis between 2 numbers

Hi Brian,

Try this logic,

sum({<SalesAge = {">=0"}, SalesAge = {"<=30"}>}Sales)

-- Regards,

Vishal Waghole

New Contributor III

Re: Help with Set analysis between 2 numbers

I know this post is several years old now, but I'll add to Massimo's solution (thank you by the way)...

Depending on your application and what it may be used for, using a variable for this would make the formula more dynamic.  Note that the extra '=' sign and the '+0' isn't necessary.  But I like to setup the expression like this because it makes shifting the value easy. I use this method to do a rolling 12 months calculation.

Sum({\$<SaleAge={">=0<=30"}>} IsSale)                                                      //Static

Sum({\$<SaleAge={">=\$(=vMinAge-0)<=\$(=vMaxAge-0)"}>} IsSale)          //Dynamic

I use this method  to do a rolling 12 months calculation.

Sum({\$<SaleAge={">\$(=vCurrentMonth-12)<=\$(=vCurrentMonth-0)"}>} IsSale)

Hope this is useful to somebody out there! 🙂

Emile