Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
MichelLalancette

Concatenate if children count greater than 1

Hi, this is my first post and I'm a new Qlik Sense user!

I'm trying to concatenate an asterisk to my dimension value if the filtered children value count is greater than 0 and do nothing (display the original) if it equals 0.

Here's the hierarchy:

Product Group -> Product, Product Flag (boolean)

A product group can contain multiple products and each product has a flag.

If the count of flag equal to 1 is greater than 0, I'd like to add an asterisk to my Product Group.

  • Carrots
    • Carrot A, Flag = 1
    • Carrot B, Flag = 0
  • Cucumbers
    • Cucumber A, Flag = 0
    • Cucumber B, Flag = 0

In this scenario, Carrots would now show up as "Carrots*" and Cucumbers would stay the same.

 

Thanks!

 

Labels (3)
1 Reply
MichelLalancette
Author

I ended up doing something like this:

=if(aggr(Count({<[Product Is Innovation]={'1'}>}[Product Is Innovation]),[Product Group])>=1,[Product Group]&'*',[Product Group])

Is there any way to improve it?