topic Re: Set Analysis Expression with Dates in QlikView

Set Analysis Expression with Dates

Anonymous — Thu, 22 Nov 2012 19:51:57 GMT

Hi everybody,

I need to convert this expression to an instruction set analysis, considering that DiasFin and DiasIni are fields in the associative model and dimensions in the table where I'm adding this expression. Usually I specified in Set Analysis the value or used a variable, but in this case neither method throws me the value I need.

if(FechaDocumento >= Date(today() - num(DiasFin) , 'DD/MM/YYYY') and FechaDocumento <= Date(today() - num(DiasIni) , 'DD/MM/YYYY')

Thanks you!!!!

Re: Set Analysis Expression with Dates

Clever_Anjos — Thu, 22 Nov 2012 20:03:53 GMT

I think

sum({<FechaDocumento={">=$(=Date(today()-num(DiasFin),'DD/MM/YYYY'))"}*{"<=$(=Date(today() - num(DiasIni) , 'DD/MM/YYYY'))"}>}Value)

Will solve your need

Re: Set Analysis Expression with Dates

chematos — Fri, 23 Nov 2012 19:45:34 GMT

Try this if the other doesn´t work:

sum({<FechaDocumento={'>=$(=Date(today()-num(DiasFin),'DD/MM/YYYY')) <=$(=Date(today() - num(DiasIni) , 'DD/MM/YYYY'))'}>}Value)

Regards

Re: Set Analysis Expression with Dates

Anonymous — Sun, 25 Nov 2012 01:30:44 GMT

Thanks for your help, but It don´t work. With If the result is this:

but with the expressions sent the result always is 0.

Re: Set Analysis Expression with Dates

Anonymous — Sun, 25 Nov 2012 03:10:34 GMT

Note that the solutions work when I have a selected range (DiasFin. DiasIni) but when I select multiple ranges shows 0. I hope you can help me.

Thanks you.

Re: Set Analysis Expression with Dates

chematos — Mon, 26 Nov 2012 11:35:51 GMT

May be you could explain in more detail how are you doing the selections and what values have each field after that selections but as I understand your problem I think that if you want to select more than one range of dates you need to have one pair of fields for each range but you can´t make more than one selection for DiasFin or DiasIni, you should have DiasFin2, DiasIni2 to make another selection and add both ranges of dates to the expression.

sum({<FechaDocumento={'>=$(=Date(today()-num(DiasFin),'DD/MM/YYYY')) <=$(=Date(today() - num(DiasIni) , 'DD/MM/YYYY'))'}>}Value)

sum({<FechaDocumento={'>=$(=Date(today()-num(DiasFin2),'DD/MM/YYYY')) <=$(=Date(today() - num(DiasIni2) , 'DD/MM/YYYY'))'}>}Value)

Regards

Re: Set Analysis Expression with Dates

jagan — Mon, 26 Nov 2012 12:20:07 GMT

Hi,

Try this

=sum({<FechaDocumento={">=$(=Date(today()-max(DiasFin),'DD/MM/YYYY')) <=$(=Date(today() - max(DiasIni) , 'DD/MM/YYYY'))"}>}Value)

Hope this should work.

Regards,

Jagan.