Discussion Board for collaboration related to QlikView App Development.
suppose i have this table in database.
i want calculate sum(amount) of records with name 'x' and before date for example 01/22/2020 in expression in a chart.
for example the answer become 20+27=47
Maye be :
View solution in original post
thank you for reply.
I put specific date in a variable.
suppose Date and specific date is not in format 'MM/DD/YYYY'.
how can i calculate both in this format.
you can change Date Format in 'MM/DD/YYYY' to another
bellow with variable :
can put Date#('01/01/2020','YYYY/MM/DD') in expression?