Solved: How to write set analysis for sales 1st March to ... - Qlik Community

Anonymous · ‎2018-09-08

How to write set analysis for sales 1st March to 2nd April? please explain?

mdmukramali · ‎2018-09-09

Hi,

You can use something like this.

but make sure Date format same as Date format in the expression ( DD/MM/YYYY)

=Sum({<Date={"$(= '>=' & '01/03/2018' & '<=' & '02/04/2018')"}>} Sales)

Thanks,

Mohammed Mukram

View solution in original post

mdmukramali · ‎2018-09-09

Hi,

You can use something like this.

but make sure Date format same as Date format in the expression ( DD/MM/YYYY)

=Sum({<Date={"$(= '>=' & '01/03/2018' & '<=' & '02/04/2018')"}>} Sales)

Thanks,

Mohammed Mukram

Anonymous · ‎2018-09-11

Thank you