topic Display data in QlikView

Display data

Anonymous — Tue, 15 Sep 2015 14:50:38 GMT

I try

=num(Sum({1< DateTest={'>=$(=MonthStart(Date(Date#('2014-06-30', 'DD/MM/YYYY'),'DD-MM-YYYY')))<=$(=Date(Date#('2014-06-30', 'DD/MM/YYYY'),'DD-MM-YYYY'))'}>}[Prix de vente TTC] ),'# ##0 ;-# ##0 ')

but it doesn't return any values , how to correct it ?

Re: Display data

sunny_talwar — Tue, 15 Sep 2015 14:54:04 GMT

See if this helps:

=num(Sum({1< DateTest={'>=$(=MonthStart(Date(Date#('2014-06-30', 'YYYY-MM-DD'),'DD-MM-YYYY')))<=$(=Date(Date#('2014-06-30', 'YYYY-MM-DD'),'DD-MM-YYYY'))'}>}[Prix de vente TTC] ),'# ##0 ;-# ##0 ')

Re: Display data

sunny_talwar — Tue, 15 Sep 2015 15:17:33 GMT

Did the above suggestion work? If not try this:

=Num(Sum({1< DateTest={">=$(=MonthStart(Date(Date#('2014-06-30', 'YYYY-MM-DD'),'DD-MM-YYYY')))<=$(=Date(Date#('2014-06-30', 'YYYY-MM-DD'),'DD-MM-YYYY'))"}>}[Prix de vente TTC] ),'# ##0 ;-# ##0 ')