topic Re: Is there a way to restrict get selected count to particular values? in QlikView

Is there a way to restrict get selected count to particular values?

varunreddy — Tue, 20 Oct 2015 16:01:10 GMT

Hi,

Is there a way to restrict get selected count to particular values?

I am looking to restrict get selected count for:

BCBS and BCBS- Accuracy.

Thank in advance!

Cheers,

Varun

Re: Is there a way to restrict get selected count to particular values?

sunny_talwar — Tue, 20 Oct 2015 16:04:06 GMT

May be use Count() function in that case:

If(GetSelectedCount(FieldName) > 0, Count(DISTINCT {<FieldName = {'BCBS', ;BCBS - Accuracy'}>} FieldName))

Re: Is there a way to restrict get selected count to particular values?

varunreddy — Tue, 20 Oct 2015 16:07:50 GMT

If I select a button, it should select BCBS and BCBS-Accuracy across dashboard. If I select button for secong time, then the selections should be cleared.

This is what I am trying to do!

Re: Is there a way to restrict get selected count to particular values?

varunreddy — Tue, 20 Oct 2015 16:09:00 GMT

If I select a button, it should select BCBS and BCBS-Accuracy across dashboard. If I select button for secong time, then the selections should be cleared.

This is what I am trying to do!

Should I use above mentioned expression in Layout?

Re: Is there a way to restrict get selected count to particular values?

sunny_talwar — Tue, 20 Oct 2015 16:12:26 GMT

Try this:

=If(GetSelectedCount(FieldName) = 0, '(BCBS|BCBS-Accuracy)')

Attaching a sample with this post for you to review.

Best,

Sunny

Re: Is there a way to restrict get selected count to particular values?

MarcoWedel — Tue, 20 Oct 2015 23:30:52 GMT

Hi,

another solution could be (using sunindia example):

hope this helps

regards

Marco