topic Re: How to Avoid Circular Loop in QlikView

How to Avoid Circular Loop

vengadeshpalani — Wed, 25 Nov 2020 16:16:04 GMT

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

PFA for sample Qvw

Re: How to Avoid Circular Loop

aarkay29 — Tue, 18 Apr 2017 14:44:08 GMT

PFA

Not sure what exactly wanted but made some changes. Please go through and let me know if you need something other than that.

Thanks,

AAR !

Re: How to Avoid Circular Loop

vengadeshpalani — Tue, 18 Apr 2017 14:53:35 GMT

in updated data model there is no connection between master calendar and Month/year table

so if i click month in the calender it show the wrong result that means it show completed job also

Re: How to Avoid Circular Loop

aarkay29 — Tue, 18 Apr 2017 15:03:33 GMT

To my knowledge this type of the data model is applicable for your requirement may be your calculation needs to be changed according to your requirement.

Can you please, post sample output where the current calculation is wrong and what number you expect to see instead .

Re: How to Avoid Circular Loop

awhitfield — Tue, 18 Apr 2017 15:13:08 GMT

Hi,

looks like you need multiple calendars, please check out the following link:

Canonical Date

Andy