Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
stou
Contributor III
Contributor III

Need to Calculate Text count

HI ,

Please refer the below Snap shot . I need the help to calculate 'Active' Count from the expression field.

Can anybody solve this problem.

 

Sub Dealer Name Active Count-22
   
Enterprises 1
Vision Limited Active
Vision Punpun 3
Electricals 0
Hardware 2
Sale 6
Electronics 7
Ganesh Enterprises 5
5 Replies
igoralcantara
Partner - Creator III
Partner - Creator III

Can you provide some more detail? From your message, I did not understand exactly what you are trying to do.

----
datavoyagers.net
David_Friend
Support
Support

Cloud or On-Prem?

stou
Contributor III
Contributor III
Author

Hi @igoralcantara this is the expression have written to get that count

(=if(Count(Aggr(if(Sum(If(Year(smonth)='2022' ,Sale))>0,1,0),Quarter,cat_))=4,'Active',Sum(Aggr(if(Sum(If(Year(smonth)='2022' ,Sale))>0,1,0),Quarter,cat_))))

but i need to calculate what is  the count of 'active' from the above expression. 

stou
Contributor III
Contributor III
Author

Hi @David_Friend  it is On-Prem.

igoralcantara
Partner - Creator III
Partner - Creator III

I believe that what is not clear to me is what is 'active'? Which of those rows do you want to count? The layout of that table does not tell me that.

----
datavoyagers.net