topic set analysis date field in QlikView

set analysis date field

Mon, 29 Aug 2011 14:33:51 GMT

Hi all,

I need help for the attached file.

I have 2 expressions I need.

1. sum(VALOARE) I need the result for a selected DATA formated in Date.

2. sum({$<{if(weekday(DATA)=0, DATA-1, DATA-2)}>} VALOARE): wich is sum of VALOARE for previous day (or satterday if selected date is Monday).

It does not work for a date formated as date. I need it like this as it is important for the other objectys in document

Can you help?

Regards,

John

Re: set analysis date field

SunilChauhan — Mon, 29 Aug 2011 14:55:13 GMT

may be like this

please see tthe attached file

Re: set analysis date field

Mon, 29 Aug 2011 15:04:48 GMT

thanks and regards.

set analysis date field

Tue, 30 Aug 2011 06:35:28 GMT

Unfortunatelly your sollution does not return the right result. While different from zero in mine, the result in all the formulas is not the one for the actual date I want to have but for the selected date.

Thanks anyway. It is a good point to work on further...

John

Re: set analysis date field

gandalfgray — Tue, 30 Aug 2011 07:17:31 GMT

I gave it a try also, but I stopped after the first two set-columns in the table since it is not clear to me what you want to achieve with the rest of them.

I cloned the table so my expressions are in the table below the original

You can have a look anyway...

/gg

Re: set analysis date field

Tue, 30 Aug 2011 07:29:50 GMT

The rest of the columns were just traials in order to achieve what I wanted.

It seems ok. Thanks a lot.

Regards,