Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I want to create a filter called branch and it should show the names as per the current year how many branches are there .
When i try to create a condition filter, it was throw me an error and it says as invalid dimension.
for I uses as
only({<year='2017'>}branch).
I was strucks here .Can you one help on this , it would be appreciated.
Thanks in advance
Thanks
Kumar KVP
May be try this
If(year = 2017, branch)
or this
Aggr(Only({1<year = {2017}>} branch), branch)
May be try this
If(year = 2017, branch)
or this
Aggr(Only({1<year = {2017}>} branch), branch)
Try
Only({<year = {'2017'}>}branch)
HI
I think the first suggestion by Sunny has suggested is what your looking for.
IF(year=2017, branch)
Only() function is used when your set analysis will only ever return a single value, the error is occurring as you will have multiple branches in your data with the year of 2017, so it doesn't know which one to return.
Mark
try like this
aggr(Only({<year = {'2017'}>}branch),branch)
Hi Sunny,
Thanks for your reply.
I tried with the if condition what you mentioned. It was selecting entire data as 2017. I didnt need this.
I want only this branch filter should show the current year possible value of branches in it.
Also when i try with having the only function it was throw as invalid error.
Thanks in advance
Thanks
Kumar KVP
Share sample app
Solutions provided by Sunny should work..
you need to calculate the condition for each value, so aggr is needed.
use
=aggr(only({1<year={'2017'}>}branch),branch)
Regards
Thanks Sunny,
It was working fine when i uses the second expression.
Thanks
Kumar KVP