Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

How to compare sales of 2 different date

‌Hi,

I want to create 2 filters for date selection and I can compare sales between 2 dates.

Thank for your help!

1 Solution

Accepted Solutions

Create second date filter as Alternative one two make selections as Individual and use this expression:

Sum({<Date={">=$(=Date(Min(Date)))<=$(=Date(Max({ToDate}Date)))"}>} Sales)

View solution in original post

3 Replies

Create second date filter as Alternative one two make selections as Individual and use this expression:

Sum({<Date={">=$(=Date(Min(Date)))<=$(=Date(Max({ToDate}Date)))"}>} Sales)

View solution in original post

Use this extension:

Qlik Branch

Hi,

The Same can be achieved by comparitive analysis first create alternate states then create 2 list box and assign the created states to the concerned list box. create a chart and in expressions use the state in set analysis.

PFA sample.

Regards

Ritesh