Total from first day till selected date

[zahidrahim_ocp]

Dear Experts,

I want to show the total quantity from the first day the data is available till the date selected in filter pane.

Suppose i have data from 01-JAN-2000 to 13-SEP-2017. Now if i selected date 13-SEP-2017 in a filter then Qlik should show the total records/sum from 01-JAN-2000 till 13-SEP-2017.

Regards,

Zahid Rahim

[zahidrahim_ocp]

NO, I have formatted it in filter pane expression.

In script it is coming as it is with timestamp information.

[sunny_talwar]

What format do you see when you use this in filter pane?

TRANSACTION_DATE

[zahidrahim_ocp]

It is coming with timestamp and thouands of duplicate date.

[sunny_talwar]

That is okay, but what is the format? May be share an image

[zahidrahim_ocp]

[sunny_talwar]

Is this TRANSACTION_DATE or =date(floor(TRANSACTION_DATE),'DD-M-YYYY')? I am looking for a filter pane with just TRANSACTION_DATE... would you not be able to do that?

[zahidrahim_ocp]

Expression is: =date(floor(TRANSACTION_DATE),'DD-M-YYYY')

Title is: TRANSACTION_DATE

[zahidrahim_ocp]

[sunny_talwar]

I am sorry man... but you are not giving me what I am asking for... I wonder how can I help you ....

Best of luck

[zahidrahim_ocp]

Do u have skype id? or can help me over Team Viewer.