Group By in Chart

[Manasareddy09]

Hello Qlik Enthusiasts,

I am trying to count values based on the dimension in Chart level using a variable. 

Trying to group 'Value' by COL .

Count({$<Value> COL})

i am getting count 1 for every value in COL . 

i want to get all the values assigned to that particular Value of COL .

Please help me solve this,

I hope you have a great day,

Thank you.

[Manasareddy09]

I am not sure where to use this formula, I have tried to use it in the second table .

And I just got the count 1 as output .

[stevejoyce]

Oh ok. 

1) You can either use this in your expressions and deselect Include zero values

or

2) If you aren't showing any measures, you can use the set analysis in a calculated dimension in place of Student_Id

=Aggr(
Only({
<Student_Id = P({<[Exam Status] = {"Done*"}, [Actual Exam Date]={">=$(=date(today() - $(vMonths)))"}>} Student_Id)>
*
<Student_Id = P({<[Exam Status] = {'PLANNED'}, [Schedule Exam Date]={"<=$(=date(today() + $(vMonths))) >= today()"}>} Student_Id)>
}Student_Id)
,Student_Id)