Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to get an expression according to the sequence of values selected from a dimension using the following expression if(match(subfield(GetFieldSelections(KPIs),',',1),null()),sum(0),sum(Sales)). If statement is not working properly.
Is anything wrong here?
Thanks,
Ruma
Hi,
Try this:
if(isnull(subfield(GetFieldSelections(KPIs),',',1)),sum(0),sum(Sales))
Hi,
Try this:
if(isnull(subfield(GetFieldSelections(KPIs),',',1)),sum(0),sum(Sales))
Hi Jaume,
Thanks for your response. Can you kindly check the pick match statement in the attached app.
It is working for subfield 1 and not for subfield 2.
Thanks in advance,
Ruma
Try this:
if(isnull(subfield(GetFieldSelections(KPIs),',',2)),'KPI not selected','KPI selected')
Not this one.In the new qvf..there is one pick match statement.
Maybe this is what you need:
pick(mixmatch(subfield(GetFieldSelections(KPIs),',',1),'A','B','C'),'Aa','Bb','Cc')
pick(mixmatch(subfield(GetFieldSelections(KPIs),',',2),'A','B','C'),'Aa','Bb','Cc')
Hi Jaume,
First pick statement is working but not the second one.Can you share the qvf ?
You're right, there was an issue. Try this:
pick(mixmatch(trim(subfield(GetFieldSelections(KPIs),',',1)),'A','B','C'),'Aa','Bb','Cc')
pick(mixmatch(trim(subfield(GetFieldSelections(KPIs),',',2)),'A','B','C'),'Aa','Bb','Cc')
It's working.Thanks a lot.