topic Re: Issue in QlikView

Issue

Anonymous — Thu, 10 Aug 2017 05:32:07 GMT

Hi All,

I have a query that I am fetching the data from transaction table which fetched on daily basis and restricting the set of filters provided by business i.e. available in sheet2 as the Level is changed on 14/5/2017 from DCA to DCM ,but DCM is not available in the excel provided by the business so this data is unavailable in May data or say 14/5/2017 is missing .Is there is any way to track the change.

Means whenever the Level is change , we can track the changes using filter

Re: Issue

neha_shirsath — Thu, 10 Aug 2017 05:49:38 GMT

Hi,

See the attached file. Hope this will help you.

Re: Issue

techvarun — Thu, 10 Aug 2017 05:52:03 GMT

Yes you can,

Read the below article to know how

Slowly Changing Dimensions

Thanks,

Varun.

Re: Issue

Anonymous — Thu, 10 Aug 2017 06:00:56 GMT

we can't remove the restriction from Sheet 1 data as its heavy data and impact entire app data

Re: Issue

petter — Thu, 10 Aug 2017 06:01:34 GMT

Yes there are ways of tracking changes. You can keep a full history of IDs and if anyone of them goes missing at a particular date you can flag and report that. It is hard to distinguish between missing and an ID not showing due to a level that is not in the filter. So if you need this it is harder to achieve.

Could you please explain more and give us more examples of data and how it changes for each day?

Re: Issue

Anonymous — Thu, 10 Aug 2017 06:07:18 GMT

how can we do that

Re: Issue

petter — Thu, 10 Aug 2017 13:14:37 GMT

Implementing "Slowly Changing Dimensions" as Varun suggest is one way of doing it. Making a limited but sufficient solution would be to keep track of the history per ID and when reading in a new spreadsheet you would compare to determine which IDs that are new, changed and which are missing and flag them accordingly.