topic Count number of records before date selected in QlikView

Count number of records before date selected

julruiz123 — Fri, 17 Feb 2012 02:47:39 GMT

Hi!

In the image there's a master calendar and a detail table, what I need is once a date is selected, it shows a chart with the number of records that have an earlier date.

Thanks!

Count number of records before date selected

jagan — Fri, 17 Feb 2012 04:40:05 GMT

Hi,

Use the expression in straight table and hide this expression column in Presentation tab.

=Sum({<DateFieldName = {'<=$(=Max(DateFieldName))'}>} ColumnName)

Hope this helps you.

Regards,

Jagan.