topic Re: Data filtering Problem (Master Calendar) in QlikView

Data filtering Problem (Master Calendar)

Tue, 09 Sep 2014 17:26:19 GMT

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,

Re: Data filtering Problem (Master Calendar)

Gysbert_Wassenaar — Tue, 09 Sep 2014 17:33:06 GMT

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?

Re: Data filtering Problem (Master Calendar)

Tue, 09 Sep 2014 17:42:45 GMT

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