topic Multiple conditions in an order when using AND operator Qliksense in App Development

Multiple conditions in an order when using AND operator Qliksense

SatyaPaleti — Sat, 16 Nov 2024 17:39:05 GMT

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 — Tue, 05 Jan 2021 11:03:27 GMT

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 — Tue, 05 Jan 2021 11:17:52 GMT

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

Anil_Babu_Samineni — Tue, 05 Jan 2021 17:31:14 GMT

perhaps this

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

SatyaPaleti — Wed, 06 Jan 2021 06:56:57 GMT

Thanks anil let me try