Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am having following fields Brand, Product, Max_pH and Min_pH. Each Brand having Min and Max pH values. Some brands having no pH values.
User wants a range slider object with pH value, when he moves a slider he want to see no of Brands and No of Products with in this pH range.
case1: when no selections in Slider object, need to show all Brands and product (with pH and without pH)
case2: when we select range in Slider object, need to show brands and products with in that pH range.
I take expression like this
if($(vsliderMin)=Min(Min_pH) and $(vsliderMax)=Max(Max_pH),
count(distinct Brand),
count({< Min_pH = {">=$(vsliderMin"},Min_pH={" <=$(vsliderMax)"}>}distinct Brand))
The issue is when i select a brand from a brand filter with no pH values, not getting count of Brand and Product.
how to write that expression.
Hi, so the products with no Ph should be shown always? to do this you can add a new field to flag products with no pH, like: If(IsNull(pHField),0,1) as hasPh
And use this field in an expression like:
count({< Min_pH = {">=$(vsliderMin"},Min_pH={" <=$(vsliderMax)"}>+<hasPh={0}>}distinct Brand)