Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ZimaBlue
Creator
Creator

How to get aggr(count() data array

Hello!

I am trying to enter a temporary array into a variable, from which I then want to output to the pivot table only those values that meet the condition "more than 30 percent" (the expression will be changed)

I tried to immediately display only the default values in the pivot table, but no formula works. So now I'm trying it through aggr.

How can I get not one number, but an array of data? Just as if I was writing an sql query with count(... group by...). I try the following formula, but it always gives me one number, not an array. And at the same time, this number is incorrect, if we talk about what I count inside the brackets. I need grouping by partner_name field.

=count(Aggr(count({<signup_time= {">=$(vDateFrom)<=$(vtodayDate)"}>} distinct user_id), partner_name, user_id))

Thanks for any tips on how I can implement this! The format of counting this array in the script does not suit me. 

Expected result of the data array:

partner_name count
partner1 320
partner2 120
Labels (3)
0 Replies