Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Yes we select both but it have to follow the specific order
perhaps this
if(GetSelectedCount(Categroy) > 0 and GetSelectedCount(Product)>0,
if(GetSelectedCount(Product) > 0 and GetSelectedCount(Categroy)>0, 0, 1))
Thanks anil let me try