Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
zhaohaifeng
Contributor III
Contributor III

Getselectedount() issue with if filter

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

4 Replies
Thiago_Justen_

What about:

GetSelectedCount (If(ChooseMonth='2017_Sep',ChooseMonth))

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
zhaohaifeng
Contributor III
Contributor III
Author

not works also, we try that. Thanks

Anil_Babu_Samineni

Should work, Can you send sample which not working?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
zhaohaifeng
Contributor III
Contributor III
Author

Hi Anil,

Shared the file in another discusstion. Thanks in advance.

https://community.qlik.com/thread/313462

Best Regards,

Haifeng