topic Count general values and selected values in QlikView

Count general values and selected values

Thu, 12 Jan 2012 12:13:33 GMT

Hello,

I need to develop a routine which will count general values of a such interval of time, if no month is selected, and if one month is selected, must count all the values of the selected month.

At this time, I have the routine below:

=IF(ISNULL(GetFieldSelections(name_month))=-1,

Count({$<dataMonth={$(#=Num((Month(AddMonths(Today(), -1)))))}, [SomeField]={"Q"}>}[SomeField]),

Count({1<dataMonth={$(#=dataMonth1)}, [SomeField]={"Q"}>}[SomeField])

)

Additionally, I will need to match values of the past year, if the selected month is january or february. How can I match that?

I've tried something like:

IF(GetFieldSelections(name_month)='jan' OR GetFieldSelections(name_month)='fev',

Count({$<dataMonth={$(#=Num(Month(Today())))}, dataYear={$(#dataYear-1)}, [SomeField]={"Q"}>}[SomeField]),

Count({1<dataMonth={$(#=dataMonth)}, dataYear={$(#dataYear-1)}, [SomeField]={"Q"}>}[SomeField])

)

Can anyone help me in this?

Count general values and selected values

SunilChauhan — Thu, 12 Jan 2012 12:28:12 GMT

getselectedcount to count selected value where as

count(fieldname) to count genral valie

count({$} fieldname) for selected value and count({1-$} fieldname) to unselected value

Re: Count general values and selected values

Anonymous — Fri, 20 Jan 2017 15:51:30 GMT

As searching for "count selected value" and this answer comes out the first few solution, think it is better to provide the correct solution here.

The correct expression for the selected value is as below:

=GetSelectedCount(fieldname)

The count({$}filename) does not work if there is no selection yet, it will return the number of all value.

Zhihong