topic Re: Column with only certain data in QlikView

Column with only certain data

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

Everyone on here is always so helpful, so here is another question....

I am working on Student discipline events and I need a column that shows just the number of events per student for the last few years. I have a column that will do a year when that year is highlighted but I want to create columns that no matter what year is highlighted it will show the number of incidents per a student for 2018 or 2017 or 2016. I am trying to see if my chronic behavior students are consistent year after year of if student has started to misbehave the last year (maybe due to outside forces we can't control for in school)

This is what I use if I click on a given year.

=max(aggr(count(distinct behaviorDetail.incidentID),Student_Name))

Is there a place in there to slip in Year = 2018 or Year = 2017?

Re: Column with only certain data

neelamsaroha157 — Tue, 04 Sep 2018 17:43:16 GMT

Can you try -

=max(aggr(count({<Year = {'2018'}>}distinct behaviorDetail.incidentID),Student_Name))

or if you want the selected year instead of hard-coding it the you can create a variable as vMaxYear=max(Year) and use this variable in the expression -

=max(aggr(count({<Year = {$(vMaxYear)}>}distinct behaviorDetail.incidentID),Student_Name))

Re: Column with only certain data

charlesdmeyer — Tue, 04 Sep 2018 18:57:50 GMT

Thanks, that did the trick.

On Tue, Sep 4, 2018 at 1:43 PM neelamsaroha1575 <qcwebmaster@qlikview.com>

Re: Column with only certain data

neelamsaroha157 — Tue, 04 Sep 2018 19:03:18 GMT

I am glad it worked. can you please close the thread. Thanks