Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Using aggr in a dimension

Hello community,

Instead of using IF statement, i used the aggr function to create a new dimension. My problem is that the conditions i wrote inside the aggr expression don't apply.

Here's my script: =aggr({<type={'11'} ,role={'1'}>}name,name). I want to show the names of the persons of both type 11 and role 1.

Thanks in advance.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Then the suggestion from Omar should work. Check the mentioned number vs. string topic and also if there are multiple names per calculation available because only() woule return NULL in such cases - a check with concat() instead of only() would show it.

- Marcus

View solution in original post

8 Replies
Partner
Partner

Try this:

Aggr( Only({<type={'11'} ,role={'1'}>} name) , name)

Creator
Creator

thanks for the answer, but it doesn't work with the only as i can have names that have my roles or types so it returns NULL.

Partner
Partner

and why u don't want to use the IF statement?

MVP & Luminary
MVP & Luminary

Do you mean an OR between both conditions, like:

Aggr( Only({<type={'11'}> +< role={'1'}>} name) , name)

Update: you should give your condition-values some attention because '11' isn't 11 and '1' isn't 1.

- Marcus

Creator
Creator

i don't want to use the if statement because because once i select a name all the filters are going to appear on the filter bar 

Creator
Creator

it's and not or

MVP & Luminary
MVP & Luminary

Then the suggestion from Omar should work. Check the mentioned number vs. string topic and also if there are multiple names per calculation available because only() woule return NULL in such cases - a check with concat() instead of only() would show it.

- Marcus

View solution in original post

Creator
Creator

Thanks for your reply, the concat works perfectly.