topic Problems with MDY function in QlikView

Problems with MDY function

Anonymous — Mon, 27 Apr 2015 13:19:06 GMT

Hi,

I have this expresion in a graph:

sum( { <fecha={"16/05/2015"}>} venta)

It works OK

but next expresion doesn't

sum( { <fecha={"Date(MakeDate(2015,5,16),'DD/MM/YYYY')"}> } venta)

It doesn't work, It doesn't find rows, and is the same filter as first expresion

Can anybody help me???

Thanks

sunny_talwar — Mon, 27 Apr 2015 13:28:38 GMT

Try this:

=Sum({<fecha={"$(=Date(MakeDate(2015,5,16),'DD/MM/YYYY'))"}>} venta)

HTH

Best,

Sunny

Mon, 27 Apr 2015 13:54:41 GMT

sum( { <fecha={"=Date(MakeDate(2015,5,16),'DD/MM/YYYY')"}> } venta)