topic Re: function with max (date) doesn't work in set analysis in QlikView

function with max (date) doesn't work in set analysis

chriscools — Fri, 15 Feb 2013 14:50:09 GMT

Hello,

i have an expression to give me the sum of € open for a certain date:

sum({<OrderDateDeliveryFrom ={"<15/2/2013"}>} OrderPriceUnitNet * OrderQtyOpen )

And this works ok, but i don't want to change the date everytime i want a current number, i tried this:

sum ({<OrderDateDeliveryFrom = Max (Date) >} OrderPriceUnitNet * OrderQtyOpen )

but it doesn't work...

can someone see what i did wrong?

thanx!!

chris

Gysbert_Wassenaar — Fri, 15 Feb 2013 15:13:46 GMT

Try:

sum ({<OrderDateDeliveryFrom = {'$(=Max(Date))'} >} OrderPriceUnitNet * OrderQtyOpen )

leonardo_raed — Fri, 15 Feb 2013 15:47:35 GMT

Hi Chris,

I always use a straight table to see how the set analysis is evaluated. You can do it keeping the label of the expression empty.

For example:

chriscools — Fri, 15 Feb 2013 16:46:58 GMT

Hey Leonardo,

i don't understand how you build your evalution and how i should read it to conclude what might be wrong.

actually i'm not at all familiar with what your doing... 🙂

grtz,

chris

chriscools — Fri, 15 Feb 2013 16:52:17 GMT

Hello Gysbert,

i tried to do the same to give me the sum for the current week by doing this, but why doesn't that work if i add the week?

sum({<OrderDateDeliveryFrom = {'$ (= Week( Max (Date)))'} >} OrderPriceUnitNet * OrderQtyOpen )

grtz,

chris

Gysbert_Wassenaar — Fri, 15 Feb 2013 17:11:18 GMT

Week returns the week number as an integer, not a date. You'll have to use something like

OrderDateDeliveryFrom = {'>=$(=weekstart(max(Date)))<=$(=max(Date))'}

Fri, 14 Nov 2014 12:47:59 GMT

Me ayudas por favor?