# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

## Basic set analysis question

Hi Experts,

I have a very simple set analysis question.

In the ordr table we have a filed  which stores the year value of the order ex. 2010, 2011, 2012, 2013 and so forth.

I am trying to get my set exprerssion dynamic and running into the following ptoblem

Original expression

sum({\$<ORD_YR ={'2013'} >} AMT)   --> Works great

New one

sum({\$<ORD_YR ={"= \$(=num(year(Today(0))))"} >} AMT)   ---> Doesn't consider the set expression results are same as sum(AMT)

An alternate that works

sum({\$<ORD_YR ={">= \$(=num(year(Today(0))))"} >} AMT)    --> please note the >= comparison

So how do I use set expression for limiting the total to based on the current year value?

Thanks,

AP.

1 Solution

Accepted Solutions
Not applicable

## Re: Basic set analysis question

Never mind removed the "=" sign and it worked..

new expression is

sum({\$<ORD_YR ={"\$(=(year(Today(0))))"} >} AMT)

3 Replies
Not applicable

## Re: Basic set analysis question

Never mind removed the "=" sign and it worked..

new expression is

sum({\$<ORD_YR ={"\$(=(year(Today(0))))"} >} AMT)

MVP

## Re: Basic set analysis question

Hi,

Try this

sum({\$<ORD_YR ={"\$(=(year(Today())))"} >} AMT)

Regards,

Jagan.

MVP

## Re: Basic set analysis question

Hi,

Check with this

sum({\$<ORD_YR ={"=\$(=num(year(Today())))"} >} AMT)

OR

sum({\$<ORD_YR ={\$(=num(year(Today())))} >} AMT)

Regards,

Celambarasan