topic Re: Chart behaving weirdly in QlikView

Chart behaving weirdly

Edge — Sat, 16 Nov 2024 02:56:39 GMT

Hi All,

I have a chart which is behaving weirdly. Could someone please advise? Is the issue in the chart or the code?

Note under the chart "Axis->Dimension Axis" properties when I disable continuous it works normal.

Below is the code for my dimension:

if(Date(ApplyMap('SemesterStartDate',ADMIT_TERM & '_' & ACAD_CAREER))-(20*7)>=APPL_SUBMITTED_DT,'-20',num(Floor((APPL_SUBMITTED_DT-Date(ApplyMap('SemesterStartDate',ADMIT_TERM & '_' & ACAD_CAREER)))/7),'00')) as [Applied Week],

The code for the expression:

Count(distinct {$<[Appliation Submit Date]={'<=$(=Date(vMaxApplDateLY))'},[Academic Year]={'$(vPrevAcadYear)'}>} AppAdmEnr.EMPLID)

Re: Chart behaving weirdly

sunny_talwar — Mon, 22 Jul 2019 12:32:08 GMT

What is weird about that chart?

Re: Chart behaving weirdly

Edge — Tue, 23 Jul 2019 05:38:23 GMT

Hi Sunny_talwar,

Many thanks for your response. well the chart below is not supposed to show the strange curve which I have circled in black in my new screenshot. It is supposed to show the cumulative number of applications over time as we get closer to the semester.

Hope this makes sense. Do I have something wrong in the formula?

Re: Chart behaving weirdly

sunny_talwar — Tue, 23 Jul 2019 11:22:40 GMT

Looking just at your expression... nothing seems to stand out which could be causing this issue. May be it is related to data? Are you able to share a sample to see the issue?

Re: Chart behaving weirdly

Edge — Wed, 24 Jul 2019 06:50:21 GMT

Hey Sunny,

I have found out that this code makes it behave badly compared to the other code:

Code with which it behaves wrong:

Count(distinct {$<[Appliation Submit Date]={'<=$(=Date(vCombined_Adm_Progn_Max_SemesterNO_Last_year_max_app_date_LY))'},[Semester Year Name]=,[SemesterNO]={$(vCombined_Adm_Progn_Max_SemesterNO_Last_year)}>} AppAdmEnr.EMPLID)

Code with which it behaves ok:

=if(Count(distinct {$<[Semester Year Name]=,SemesterNO={$(=vCombined_Adm_Progn_Max_SemesterNO)},[Appliation Submit Date]={'<=$(=Date(today()))'}>} AppAdmEnr.EMPLID)>0,
rangesum(Above(Count(distinct {$<[Semester Year Name]=,SemesterNO={$(=vCombined_Adm_Progn_Max_SemesterNO)},[Appliation Submit Date]={'<=$(=Date(today()))'}>} AppAdmEnr.EMPLID),0,RowNo())))

Any Idea what is the difference? I have attached 2 screenshots to show this. BTW I don't understand the code much as I am not the one who created it. I think I need both codes because it is a comparison of this year vs last year. So each code works differently. When the code calculating the line changes, it will be because a slicer has changed. You can even see that in the images.

Many thanks in advance for your help. Sorry if I am not able to share some data.