I am trying to count the age group from 0-9/10-14/15-19/20-59/60-69/>=70 and Total of Male and Female Patients.
I was also want to count 5 different options from option set. I have used V{value_count} in the expression and (A{nRl90sBvPdp} == 'NP-OPT-Female' && A{Kyb6NxBgYgH} <= 9) && A{e3OlqcOxTVM} == 'NP-OPT-New' in the filter for first case and also V{value_count} in the expression and A{DMu6Vp6wguy} == 'NP-OPT-Brahmin/Chhettri' && A{nRl90sBvPdp} == 'NP-OPT-Female'.
The output for first is Not Defined and Second, it seems like second is not working because there is no sign of Indicator showing in either form or dashboard.
At first sight, it appears that that the expression and filter seem to be valid but are the values that are being compared the same. For instance, in A{Kyb6NxBgYgH} <= 9 is this attribute an option set or a number because if it is an option set then A{Kyb6NxBgYgH} <= 9 would certainly return undefined. If it is an option set then then you need to compare with the possible options in the option set such as A{Kyb6NxBgYgH} == '0-9'. The same applies for the other attribute.
Additionally, it is important to make sure you ran the Analytics Tables export in the Data Administration app, and just in case try clearing the browser cache using the Browser Cache Cleaner app.
@Gassim A{Kyb6NxBgYgH} <= 9 I have indicators 0-9, 10-14,15-19,20-59,60-69 and >=70
I simply apply condition for the value , the program checks the age and apply condition
In Expression I write V{value_count} and filter : (A{nRl90sBvPdp} == ‘NP-OPT-Female’ && A{Kyb6NxBgYgH} <= 9) ( i.e if gender = male and age is <=9) . It is supposed to count the value but returns false
In next I do value count in expression A{DMu6Vp6wguy} == ‘NP-OPT-Janjati’ && A{nRl90sBvPdp} == ‘NP-OPT-Female’ (i.e caste = janajati and gender = female) , It should have also counted the value. But it also returns false.
Thanks! In the form I actually see the value displayed “Male” so how are you comparing with a different value “NP-OPT-Female”. The values compared need to be the same as they are being input.
@Gassim Sorry for the wrong picture! This is the correct pricture. The issue is still the same, I wonder is it because of the Cache or the expression is incorrect.
Thank you for the new screenshot but it’s still the same idea, the value I see displayed “Female” in the options is not the same as the one in the expression.
@Gassim I am using option code in the expression and in the form I am using the option. So in the value it shows gender (male/female).The option code for Female is “NP-OPT-Female”. It only shows False in the indicator. What I need is number of Females and Males in number.
