How to compare sales of 2 different date

[caovanhau1507]

‌Hi,

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

Thank for your help!

[balabhaskarqlik · Accepted solution]

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)

[balabhaskarqlik]

Use this extension:

Qlik Branch

[Anonymous]

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