Discussion board where members can get started with Qlik Sense.
I have below data which i want to calculate all on date selected. and also a trend for 2 dates selected.
Now if i select 06Jan2017 it should 60 (Sum of all previous records). and if i select 06 and 07-Jan2017 it should show trend:
You can use Cumulative sum in this case(Using RangeSum())
may be this
Thank you for the reply. your expression returns running total without any filter. Applying a filter only shows that current record value only.
I want to use it with data filters. Can i have one example please.
It keep displaying zero.
LOAD Date(Date#(Trdate,'DD-MMM-YYYY'),'DD-MMM-YYYY') as Trdate,Amount Inline [ Trdate Amount 01-JAN-2017 10 02-JAN-2017 10 03-JAN-2017 10 04-JAN-2017 10 05-JAN-2017 10 06-JAN-2017 10 07-JAN-2017 10 ](delimiter is spaces);