Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Data filtering Problem (Master Calendar)

Hi Everyone,

                7 Master tables and one Transaction Table in my database.I have created common Calendar.

I have Connected all the Master tables  with Transaction table  by using Key fields.

Common calendar is also connected to Transaction table. when i am filtering using month dimension ,data is filtering only for the records in Transaction table for master tables.I need complete data in Master table.

Ex: I have company table if i m filter using master table i m getting 11579 company names.

     same expression ,if i do filtering in Transaction table i m getting around 7000 Company names.

Any Suggestions would be greatly Appreciated.

please find snapshot,

Tags (2)
2 Replies

Re: Data filtering Problem (Master Calendar)

Sounds like you have companies in your master table without records in your transaction table. Your screenshot is meaningless without the actual data. Can you create a small document that demonstrates the problem?


talk is cheap, supply exceeds demand
Not applicable

Re: Data filtering Problem (Master Calendar)

yes correct i have Companies in my master table and that records not available in Transaction table .How to get complete count of records in Master table

PFA,

Regards,

Divya

Community Browser