topic Re: count bars on a bar chart in QlikView

count bars on a bar chart

Thu, 14 Aug 2014 14:55:16 GMT

I want to know how many charts there are in a barchart:

This chart should give the amount of 12 because there are 12 months shown.

Here it should give 5 because there are 5 weeknumbers shown.

Why do i want to know this? the red line ("gemiddelde"= average) doesn't work properly. in the top chart it does work because i count all the consults and divide them through 12. in the second chart he should count all de consults but divide them through 5. Problem is that he still divides through 12.

Re: count bars on a bar chart

MK_QSL — Thu, 14 Aug 2014 15:36:55 GMT

COUNT(DISTINCT Month)

Re: count bars on a bar chart

Fri, 15 Aug 2014 07:23:21 GMT

Thanks!! so easy... didn't think about that :$

Re: count bars on a bar chart

Fri, 15 Aug 2014 07:44:00 GMT

the problem i have right now is that it aren't all months. It's a drilldown group with months, weeks, days, etc in it. Is there a way where i can =count(DISTINCT GetCurrentField(Tijd))

Because this doesn't work

Re: count bars on a bar chart

Fri, 15 Aug 2014 07:58:48 GMT

You can use the =GetCurrentField(MyDateGroup) to obtain the current level in the group and use an expression like this:

Variable: v_current_date "=GetCurrentField(MyDateGroep)"

And use an expression with an IF statement to get the right calculation depending on the selected level:

if(v_current_date='Month',

COUNT(DISTINCT Month),

if(v_current_date='Week',

COUNT(DISTINCT Week),

COUNT(DISTINCT Day)

))

Re: count bars on a bar chart

MK_QSL — Fri, 15 Aug 2014 08:07:57 GMT

=COUNT(DISTINCT $(=GetCurrentField([Group Name])))