Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Hi guys,Need help on this

I have a star schema data model where i have 2 fact tables and one link table.i have a complaint dimension which consists of complaint start date and complaint end date and one master calendar which consists of dates.i need to match complaint start date and complaint end date from complaint dimension to master calendar dimension.

2 Replies
mallikarjun_h
New Contributor III

Re: Hi guys,Need help on this

Hi Susshma,

You can use interval match function.

Not applicable

Re: Hi guys,Need help on this

i have already tried interval match function.if we do so then there will be link between complaint dimension and master calendar.But our data model is star schema.