Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Date parameter in a Multi Box object

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

                                                                                          Ok

Please kindly assist on how to go about this.

Regards

1 Solution

Accepted Solutions

Re: Date parameter in a Multi Box object

Hi,

Use if()

try like

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

Regards

Regards,
Prashant Sangle
4 Replies

Re: Date parameter in a Multi Box object

Hi,

Can you write complete expression??

Regards

Regards,
Prashant Sangle
Not applicable

Re: Date parameter in a Multi Box object

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

Regards

Re: Date parameter in a Multi Box object

Hi,

Use if()

try like

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

Regards

Regards,
Prashant Sangle
Not applicable

Re: Date parameter in a Multi Box object

Thanks, it works

Community Browser