topic how to compare current date with last date ? in QlikView

how to compare current date with last date ?

Fri, 07 Oct 2011 23:04:18 GMT

hi, i have a problem, i need to compare a especific date with a last date (for example 1/10/2011 with 1/10/2010) and this show the sum of sales,

I created a report with these data but the chart shows me the information of the two separate years and I need to display them in the next column.

i attached file with the example, i hop you can help me please

Re: how to compare current date with last date ?

Sokkorn — Sat, 08 Oct 2011 02:27:15 GMT

Hi Beto,

Actually the main purpose of set analysis is used to compare between (Year, Quarter, Month, Week). So you should remove one dimension called <fecha> in you pivot table.

Try to use one dimension (cliente) and two below expression:

1. For the current selection Year: SUM({<año={$(=Max(año))}>} ventas)

2. For last year: SUM({<año={$(=Max(año-1))}>} ventas)

Check the attached file.

Hope this help.

Regards,

Sokkorn

Re: how to compare current date with last date ?

Mon, 10 Oct 2011 18:57:31 GMT

hi sokkorn , , i tried to do it before, bu t i need to present the data per date like the next way

customer, date, sales 2011, sales 2010

NT,10/10/2011,5000,4500

NT,09/10/2011,6000,5500

NT,08/10/2011,7000,6500

i try to do with function TOTAL sum({1}total <fecha>ventas ) ,but this way show all the dates and it does not respect the selection, it's possible to add more function (aggr) in this function , i don't know how to do it

Re: how to compare current date with last date ?

swuehl — Mon, 10 Oct 2011 19:15:01 GMT

Hi Jorge,

maybe like attached?

I changed your second dimension to:

=num(Day(fecha),'00')&'/'&num(month(fecha),'00')&'/'&$(v_año)

Hope this helps,

Stefan