Set Analysis Expression Check ?

[ganeshreddy]

Hi All,

I want to fetch data between dates by using set analysis and variables. i am not getting desired results. Can any one help me on this.

Please find attached QVW

Cheers,

Ganesh

[morganaaron]

I didn't change the let expressions on your main tab, but there's a disconnect between what you're passing to the variables and what you're trying to do.

You're passing a date variable to your "from" and "to" fields, but only taking the day - then you're trying to create a date from this day? Doesn't make any sense. I changed your variable values to simply be two dates from your list and simplified your set expression to look between those set values.

Have a think about how you want to set your max and min values, as this is what's causing your issues.

[robert_mika · Accepted solution]

Change your variable to

=Min([SalesDate])

and

=Max([SalesDate])

expression

=Sum({$<SalesDate={">=$(vFromDate)<=$(vToDate)"}>}Value)

You will be able to manipulate your Chart thru Listbox

[ganeshreddy]

Thank you Rob and Aron,

What if, i want to change Min and Max dates on the fly. Is there any other solution for this.

Cheers,

Ganesh

[robert_mika]

Try Inputt Box or Calendar