Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
how can I create a set analysis where I have to filter for a specif value and also make the calculation independent from that field, where the value is presented.
Example:
sum({$<country={'Hungary'}>}VALUE)
if a user selects for ex country = India it should not show 0 but still the value from Hungary.
Important point the calculation should respond the other field selection so 1 as set Identifier can not be used.
Best,
Dan
The expression does what it shoud do:
AT is selected, CH is in expression, value for CH is shown.
But be aware that you use the same field (eg. not Year in expression and MonthYear in selection)
Regards
Hi
Try using this
if(GetSelectedCount(country) =0,sum({$<[country]={'Hungary'}>}VALUE),if(sum(VALUE)>0,sum(VALUE),sum({$<[country]={'Hungary'}>}VALUE)))
Hope it helps
Thanks
Hi, Dan, this is rather interesting case.
Can you try with this:
sum({$<country=, country={'Hungary'}>}VALUE)
The expression does what it shoud do:
AT is selected, CH is in expression, value for CH is shown.
But be aware that you use the same field (eg. not Year in expression and MonthYear in selection)
Regards
Dont know what happened but ye.
After F5 it is behaving correctly same.