topic Re: Custom field in Qlikview in QlikView

Custom field in Qlikview

Smeenakshi23 — Thu, 15 Feb 2018 09:41:37 GMT

I have 3 dim table and 1 fact table.

Date table

vendor table

Service type table and fact table.

All dim table is linked to fact table with unique key.

I want to restrict the date for 180 days name that as a custom filed. For instance = if(date>=today and date<=today()+180) as Date custom.

I want to restrict the same in vendor and service type table.. As those table doesn't have date filed. how to do achieve it,

If I restrict using linked key, my whole report will get restricted right..

I want custom field alone

Re: Custom field in Qlikview

YoussefBelloum — Thu, 15 Feb 2018 09:49:36 GMT

Hi,

Maybe I'm missing something but why you want to restrict tables (service & Vendor) by date when you know that these tables don't have dates ?

what is the main purpose here ?

Re: Custom field in Qlikview

karthikoffi27se — Thu, 15 Feb 2018 10:05:14 GMT

Hi Soundarya,

There is no date field, means it will be filtered for all. You don't have to worry about dimension table.

Many Thanks

Karthik

Re: Custom field in Qlikview

shiveshsingh — Thu, 15 Feb 2018 10:55:27 GMT

If you filter for one, the linked tables will also be filtered.

Re: Custom field in Qlikview

Peter_Cammaert — Thu, 15 Feb 2018 11:14:11 GMT

If you don't want your entire data model to be reduced by this last-180-days-only selection, use filter expressions or set analysis to reduce the custom field values displayed in particular objects. Such reductions will not affect any other displays.