Custom field in Qlikview

[Smeenakshi23]

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

[YoussefBelloum]

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 ?

[karthikoffi27se]

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

[shiveshsingh]

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

[Peter_Cammaert]

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.