topic Re: Expression Help! in QlikView

Expression Help!

jameswills — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

I'm after some help with what I'm sure is a simple expression. Still can't get a handle on the syntax layout

I have a date field (DD/MM/YYYY) and a select in field button which identifies dates prior to today i.e. Overdue. The working button syntax is '='<' & Date(Today(),'DD/MM/YYYY').

What I'd now like to do is visualise a count of these overdue dates by another dimension (DIVISION). I've created a bar chart with DIVISION as the dimension so am looking for help in creating the expression syntax to calculate a count of dates prior to Today() please?

Re: Expression Help!

Anil_Babu_Samineni — Tue, 28 Nov 2017 09:32:37 GMT

May be this?

Count({<datefield = {"<$(=Date(Today(),'DD/MM/YYYY'))"}>} datefield)

Re: Expression Help!

Anil_Babu_Samineni — Tue, 28 Nov 2017 09:33:13 GMT

When you say prior it should this?

Count({<datefield = {">=$(=Date(Today(),'DD/MM/YYYY'))"}>} datefield)

Re: Expression Help!

jameswills — Tue, 28 Nov 2017 11:02:01 GMT

Thanks Anil, both work great but it's the second expression which is returning what I need. Thanks for the reply