topic Current Month Guages in QlikView

Current Month Guages

Fri, 04 Mar 2011 17:20:18 GMT

Im am trying to create a guage wich will desplay data for the current month only. so my expression is comparing the month of what I am trying to count against the systems month using month(today()) see below:

if(QualityMonth = month(today()) , count(distinct(Qmel.QualityNotif)))

However this returns nothing and the guage is not working. Can someone tell me what I am doing wrong??

Current Month Guages

pover — Fri, 04 Mar 2011 18:09:35 GMT

Try

count( distinct if(QualityMonth = month(today()), Qmel.QualityNotif))

Regards.

Current Month Guages

johnw — Sat, 05 Mar 2011 01:46:38 GMT

Or more efficiently if less clearly:

count({<QualityMonth={'$(=month(today()))'}>} distinct Qmel.QualityNotif)

Current Month Guages

Mon, 07 Mar 2011 19:06:05 GMT

I've tried this and a number of other solutions, but I'm still stuck. It's not returning the correct number.

AW:Re: Current Month Guages

brenner_martina — Mon, 07 Mar 2011 19:16:02 GMT

Hi,

what is the type of your field QualityMonth? The problem is, that Month(Today()) gives you a dual (Text,Number). Try to enter a field in your script as the Number of QualityMonth:

Num(QualityMonth) as NumQualityMonth

Than anter a variable vActMonth with: =Num(Month(Today()))

Than try this:

count({<NumQualityMonth={$(vActMonth)}>} distinct Qmel.QualityNotif)