GetSelectedCount()/GetFieldSelections() for If statements

[zhaohaifeng]

Hi All,

Now we used filter pane(Named ChooseMonth), expression as below,

if(I_Time_Key>v_Daily_MonthBegin_lastyear

AND I_Time_Key<=v_Daily_MonthBegin,

ChooseMonth).

When we select from ChooseMonth, we want to judge what we selected and the count we selected, but when we use GetSelectedCount(ChooseMonth) or GetFieldSelections(ChooseMonth), it not works. May i know how to achive the fuction? Thanks.

[YoussefBelloum]

Hi,

to count how many ChooseMonth you have selected, you can use GetSelectedCount(ChooseMonth)

to get the values you selected on ChooseMonth, you can try this: Concat(ChooseMonth,',')

[zhaohaifeng]

Hi,

For value Concat(ChooseMonth,','), it works.

But for count GetSelectedCount(ChooseMonth), the count always 0 , no matter what you sleected. Do you know the reason. Thanks.

[YoussefBelloum]

It is weird.. would you be able to attach sample app ?

[avinashelite]

In which fields you have made the selections ?? could you please share the sample app

[zhaohaifeng]

Attached. thanks

[zhaohaifeng]

Attached. thanks

[YoussefBelloum]

the ChooseMonth field is empty on the attached file

[zhaohaifeng]

Please selecte one country in the Qs, and refresh the QS use attached data source as we set scetion access for only one country in actual report. Thanks.