set Analysis

[#1]

Hi to All,

I have the data from 01 Dec 2008 to 03/02/2015... if we select any date between these dates,,i want get the data from 01/12/2008 to selected date. 

My expression Like....

=sum({<postingdate={"<=$(=date(max(date)),'DD/MM/YYYY))"}>} quantity_in Base)

Above expression is not working pls help me.

I want display data from starting date to Selected date....

I did n't store any dates into variables..

i have my column Posting date,

Pls give me expresion for that...

Thanks for advance

please help me....

chandra

[Anonymous]

Can you just attach sample application.

[PrashantSangle]

Hi,

Check Date format.

and if possible share sample app.

Regards

[jonathandienst]

Hi

You have a misplaced bracket and you need square brackets around the field with a space in the name:

=sum({<postingdate={"<=$(=date(max(date),'DD/MM/YYYY'))"}>} [quantity_in Base])

HTH

Jonathan

[#5]

Hi Jonathan,

thans for ur reply

its not working.

give me suggestion.

[#6]

Hi Max,

i entered both formatts like (1) DD/MM/YYYY

                                           (2)MM/DD/YYYY

     i checked both this formatts but its not working max.

Thanks for ur reply.

[#7]

Hi Chandra,

try this

=sum({<postingdate={">=$(=date(max(date)),'DD/MM/YYYY))"},   postingdate={"<=$(=date(max(date)),'DD/MM/YYYY))"}>} quantity_in Base)

This will work

Regards,

Lalit

[#8]

Hi to All,

Not getting Answer..

Thanks for ur reply.

[robert_mika]

A sample of file would be helpful.

[jerrysvensson]

Put this in a variable to verify that your formula works.

date(max(date),'DD/MM/YYYY'))

I don't know why you are complaing on not getting answers, most people on the forum is not paid by Qlik.

We help out when we have time.