Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
vengadeshpalani
Contributor

how to avoid circular loop

Hi

in the dashboard, I show the count of the pending job based on date wise month wise and year wise

but In data model, JobID = MJobID = YJobID  if I maintain the same name it make circular loop

how can I make the perfect data model

Screenshot_1.png

2 Replies

Re: how to avoid circular loop

why you have created two separate tables Year & Mont?


You already created the YearName & MonthName fields in Calendar table which is connected to Fact table with Date. There is no need to create the two separate tables

vengadeshpalani
Contributor

Re: how to avoid circular loop

in my scenario

job was open in 28/Jan/2017 and closed in 02/Feb/2017 means

in Date wise, we need to show open job count as 1  (28/Jan to 01/Feb )
in Month wise we need to show open job  count as 1 for Jan and Zero for Feb


please find QVS file

Screenshot_2.png