topic Re: Date parameter in a Multi Box object in QlikView

Date parameter in a Multi Box object

Fri, 13 Mar 2015 11:31:55 GMT

Hi all,

I am trying to use the date parameter below in a multi box object

=WHERE ([Sales Date] > '31/12/2009')

I used the steps below but no success:

Multi Box Properties

General Tab

Edit (and Expression) Boxes

=WHERE ([Sales Date] > '31/12/2009')

Apply

Please kindly assist on how to go about this.

Regards

PrashantSangle — Fri, 13 Mar 2015 11:47:15 GMT

Hi,

Can you write complete expression??

Regards

Fri, 13 Mar 2015 11:51:23 GMT

I can write COUNT and SUM expressions but not WHERE DATE GREATER THAN.

Regards

PrashantSangle — Fri, 13 Mar 2015 11:55:51 GMT

Hi,

Use if()

try like

if(sales date>'31/12/2009','Apply','ok')

Regards

Fri, 13 Mar 2015 12:25:27 GMT

Thanks, it works