topic Re: LastWorkDate with set analysis in QlikView

LastWorkDate with set analysis

carlos13 — Sat, 18 Jan 2014 16:44:55 GMT

If I can help make this set analysis that does not work me.

Sum({$<dateperiodo={$(=LastWorkDate((dateperiodo-32 ) ,1 ))}>} Monto).

if I select the date: 31/01/2014

I want to get the date 30/12/2013 and sum Monto

Thanks and best regards,

Re: LastWorkDate with set analysis

Gysbert_Wassenaar — Sat, 18 Jan 2014 17:18:38 GMT

Try using a variable. See attached qvw. You might need to make sure that the variable returns the value in the right date format by using the date() function.

Re: Re: LastWorkDate with set analysis

carlos13 — Sun, 19 Jan 2014 12:03:04 GMT

not work, if you can help me.

Thank.

Re: LastWorkDate with set analysis

Gysbert_Wassenaar — Sun, 19 Jan 2014 15:41:38 GMT

It does work. Select 31/10/2013 instead. You'll see that your table will show a row for 30/09/2013. It's simply that your table doesn't have any records for 29/10/2013 so if you select 30/11/2013 you wont get a result.
BTW if you want both values displayed on the same row you'll have to remove the dimension from the straight table.