Multiple conditions in an order when using AND operator Qliksense

[SatyaPaleti]

Hi Friends,

Can some one help me to resolve the following issue.

I am using a condition in a Variable like

if(GetSelectedCount(Categroy) > 0 and GetSelectedCount(Product)>0, 1,0) I am getting output 1 when I made selections on Category & Product.

But if i make selection on PRODUCT 1st and CATEGORY 2nd then output should be 0.

In simple words

if  selections on Category 1st and Product next then output should be 1

if  selections on Product 1st and Category next then output should be 0

Can someone please help me to resolve this. It's urgent

Thanks and Regards,

Satya

[Anil_Babu_Samineni]

Anyway, in the end you will select both so condition should work what you gave above. If that is not working, How Qlik is working try to debug?

[SatyaPaleti]

Yes we select both but it have to follow the specific order

[Anil_Babu_Samineni]

perhaps this

if(GetSelectedCount(Categroy) > 0 and GetSelectedCount(Product)>0,
if(GetSelectedCount(Product) > 0 and GetSelectedCount(Categroy)>0, 0, 1))

[SatyaPaleti]

Thanks anil let me try