How to deselect month field when YTD selected in Qliksense.

[nikhilgarg]

Hello All,

I am facing an issue where i have to disable selection on month field when YTD selected and vice-versa in Qliksense.

I know how to do it in Qlikview but in QLiksense, i tried but no success.Can  anyone help in this?

Thanks,

Nikhil Garg

[agigliotti]

could you add more informations on what you are trying to do ?

[nikhilgarg]

Hello,

I have YTD and Month as 2 separate filters in QLIKSENSE as you can see in the attached image. My scenario is:

When i select on YTD filter, my MTD filter should get disabled and if i select any of the month in Month filter then YTD filter should get disabled. Hope this time i ahve make my scenario more clear

[OmarBenSalem]

It's still not clear Nikhil...

What's the values of your YTD?

Where is the MTD filter in ur attached screenshot?

What do u mean by disabled?

[agigliotti]

what do you mean with "get disabled" ?

[mohan_1105]

Hi,

Maybe this could help:

if(GetSelectedCount(MTDFilter)>0,sum({<YTDFilter=>}Your_Measure),

if(GetSelectedCount(YTDFilter)>0,sum({<MTDFilter=>}Your_Measure)))

[nikhilgarg]

Hey,

In YTD filter, we have one value as 'YTD'

In Month filter, we have values from Jan, Feb, Mar to Dec

and by disabled i mean that, if i select YTD, all values in Month filter should get unassociated.

If i select any value from Month filter, YTD value should get unassociated

Thanks

[OmarBenSalem]

That's clear to me:

Well, in ur Month field; alter it as follow:

=if(GetSelectedCount(YTD)>0,'Not avaliable',MonthField)

and vis versa:

Per analogy :

=if(GetSelectedCount(Sales)>0,'Not avaliable',LeadTime)

=>