Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco223
New Contributor III

Using get selected count on a dimension that has an if statement in it.

  Hi, I have a dimension in the fitler pane of a dashboard that uses an if so that the current month cannot be selected. See below

=If(not Match([Fiscal - Period Name], '$(vCurrentPeriodName)'), [Fiscal - Period Name])


this works well, however, I am also attempting to update the column name with that dimension if it selected. For example, if March is selected the column would say 'March Full Month'

Below was working fine until I added the IF condition to the dimension. Do you know how I can

GetSelectedCount([Fiscal - Period Name])>0,

Only({1<[Fiscal - Period Id]={$(=Max([Fiscal - Period Id]))}>}[Fiscal - Period Name ])&' Full Month')

How can I get GetSelectedCount to work on a dimension that has an If statement in it?

Thanks!

2 Replies
MVP
MVP

Re: Using get selected count on a dimension that has an if statement in it.

So, this is not working?

If(GetSelectedCount([Fiscal - Period Name])>0,

Only({1<[Fiscal - Period Id]={$(=Max([Fiscal - Period Id]))}>}[Fiscal - Period Name ])&' Full Month')

What does it do?

danielco223
New Contributor III

Re: Using get selected count on a dimension that has an if statement in it.

Its not, just had a dash through the title. I think the issue is with the filter dimension because if I change...

=If(not Match([Fiscal - Period Name], '$(vCurrentPeriodName)'), [Fiscal - Period Name])

...to just [Fiscal - Period Name]

It works.

Community Browser