Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

selection

Hi everyone,

now I have sheet that compares between different data from different tables ... the problem is that each chart done doesn't see the selection made in the filter I have tried more than one way but it doesn't work

so the filters is made using :

Year([MasterCalendarDate.AllDateTime])

Month([MasterCalendarDate.AllDateTime])

Day([MasterCalendarDate.AllDateTime])

the tables on the other hand has the following calculation in it :

(sum (interval ([TechTimeLog.TechStopTime] - [TechTimeLog.TechStartTime])))

note that in

MasterCalendarDate.type = 'TechTimeStart'..................... was created by me in the master Date table so that the dates in the master date table that were pulled from [TechTimeLog.TechStartTime]  will have 'TechStartTime  ' in front of them in a separate columns

So any suggestions

2 Replies
lakshmikandh
Valued Contributor II

Re: selection

Try to keep Date as Alias name when loading the data from both the tables

rittermd
Honored Contributor

Re: selection

You need a common field in both tables so that Qlik will associate them.