Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rupaliqlik
Creator
Creator

How to handle multiple dates

Hi,

This is interview scenario.

I Have 3 charts and 3 diffrent date field.
1st chart is calculated on Production Date.
2nd chart is calculated on Despatch Date.
3rd chart is calculated on Supplier Date.
I have MasterCalendar from which Year and Month came.Master calendar is island in datamodel not connected with model.
When I select Year and month all the 3 charts should calculated correctly.

1 Reply
MayilVahanan

HI Rupaliqlik,

In that case, you can use P() function in set analysis like below

Count({<ProductionDate = p(Mastercalendar.Date)>} Distinct Products)

But it impacts performance, to avoid this, need to change the data model to link the 3 fields with master calendar. 

Thanks & Regards,
Mayil Vahanan R