topic Set Analysis Expression Check ? in QlikView

Set Analysis Expression Check ?

ganeshreddy — Mon, 13 Apr 2015 08:52:12 GMT

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

Re: Set Analysis Expression Check ?

morganaaron — Mon, 13 Apr 2015 08:59:10 GMT

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.

Re: Set Analysis Expression Check ?

robert_mika — Mon, 13 Apr 2015 09:14:09 GMT

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

Re: Set Analysis Expression Check ?

ganeshreddy — Mon, 13 Apr 2015 09:20:58 GMT

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

Re: Set Analysis Expression Check ?

robert_mika — Mon, 13 Apr 2015 09:34:19 GMT

Try Inputt Box or Calendar