Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for 
Search instead for 
Did you mean: 
pavan242
Contributor
Contributor

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

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

1 Solution

Accepted Solutions
mdmukramali
Specialist III
Specialist III

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

2 Replies
mdmukramali
Specialist III
Specialist III

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

pavan242
Contributor
Contributor
Author

Thank you