Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I try to perform the following expression (aggr function in if conditional) but it doesn't work:
if(GetFieldSelections([Select Type])='Region',Region,
aggr(if(isnull(NAME),'Other',NAME),NAME))
Could you please advise?
Thanks,
Ruti.
Hi,
u can't use aggregation in your case. only when you having functions like Max, sum, count , avg etc. then the aggregation function will work.
may u can try like this,
if(GetFieldSelections([Select Type])='Region',Region,
if(isnull(NAME) or len(trim(NAME))<=0,'Other',NAME))
also check this article about the aggregation function in qlik
https://www.analyticsvidhya.com/blog/2014/02/aggr/
Thanks,
Deva
Thank you for your response ..
I need the aggr function...
Hi Ruti,
Could you share your samples data and purpose for if condition ?
Regards,
Justin.
Why do you need it? Can you elaborate on this please?
I think you should fix this in the script rather than using aggr.
I would suggest to add an if in your script.
Kr,
Dion
Dear Ruti,
I guess that you could mark this itens on load script, then create a aggr function.
Like this on load:
if([Select Type]='Region',Region,'Other') as NAME