Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
NO, I have formatted it in filter pane expression.
In script it is coming as it is with timestamp information.
What format do you see when you use this in filter pane?
TRANSACTION_DATE
It is coming with timestamp and thouands of duplicate date.
That is okay, but what is the format? May be share an image
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?
Expression is: =date(floor(TRANSACTION_DATE),'DD-M-YYYY')
Title is: TRANSACTION_DATE
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
Do u have skype id? or can help me over Team Viewer.