Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Now we faced the challenge that, if we set if in the filter , than getselectedcount function not works, always show 0 value. Sample as below,
For example we want to judge the count for field Choosemonth,
if we just put Choosemonth in the filter then the Getselectedcount(Choosemonth) works fine,
if we put if in the filter, for example if(ChooseMonth='2017_Sep',ChooseMonth), then if we selected from filter, getselectedcount(Choosemoth) not works. So we cant use if for getselectedcount() function? Any ideas? Thanks.
Best Regards,
Haifeng
Hi,
You can use this expression in your filter:
=if(ChooseMonth='2017_Sep',Aggr(ChooseMonth,ChooseMonth))
To get the count simply use:
Getselectedcount(Choosemonth)
Br,
KC
Hi haifend,
Instead of getselectedcount use simple count .
Thanks,
Arvind Patil
Hi Haifeng,
Just modify your expression like this
=if(ChooseMonth='2017_Sep',Aggr(ChooseMonth,ChooseMonth))
Br,
KC
Hi KC,
I think the expression you mentioned will display the value what we selected, not the count how many we select. Any other ways? Thanks.
Best Regards,
Haifeng
Hi Arvind,
For your suggestion, if we dont select the choosemonth, the value should be all the possible count, in this case, should be 48, Not 0. Thanks.
Best Regards,
Haifeng
Hi,
You can use this expression in your filter:
=if(ChooseMonth='2017_Sep',Aggr(ChooseMonth,ChooseMonth))
To get the count simply use:
Getselectedcount(Choosemonth)
Br,
KC
pfa
Thanks KC! It works. May i know the reason? Thanks in advance.
Best Regards,
Haifeng
Hi KC,
One more question, if we use other field in the if judge, then the filter will pop up another one.
For example, we use I_TIME_Key in the case, if we selected the filter, then both i_time_key and choosemonth pop up in the selection bar . Any ideas on that? Thanks.
Best Regards,
Haifeng
Sorry , i am still not clear what you are trying to achieve.
Br,
KC