Aggr lost some values

[ZimaBlue]

Hello!

I use the following expression as dimension to get an array of data for keywords that contain >= 10 registrations in period.

=aggr(if(count({<signup_time= {">=$(vDateFrom)<=$(vtodayDate)"}>} distinct user_id)>=10, keyword,0),keyword)

However, 2 keywords are lost in this array - aggr does not output them for some reason. They have exactly 10 registrations. Why can this happen?

[marcus_sommer]

Maybe not all conditions are really fulfilled for those keywords. Just put your calculated dimension within a table-chart and reduce your threshold to a lower number and then using some count() with and without distinct on user_id, keyword and maybe their combination with user_id&keyword or also a combination of user_id & ' - ' & keyword & ' - ' & signup_time within a concat(). It should now show which data are really there and how often.

- Marcus

[ZimaBlue]

Hello! Thank you for your reply! Unfortunately, this is just another qlik sense error, since I replaced 0 with null() in my expression and these values appeared

[marcus_sommer]

There are options within the object-properties to hide NULL within the dimension and expression. Just enable them.

- Marcus