Discussion board where members can get started with Qlik Sense.
I try to perform the following expression (aggr function in if conditional) but it doesn't work:
Could you please advise?
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(isnull(NAME) or len(trim(NAME))<=0,'Other',NAME))
also check this article about the aggregation function in qlik
Thank you for your response ..
I need the aggr function...
Could you share your samples data and purpose for if condition ?
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.
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