Qlik View Filter

[vijayit43]

In My QV Dashboard Customer  Wise Category Show  When ((Total Weight/TotalSale)*100)>90 then Silver,When >100 then Gold, When >110 Then Diamond Where Total Sales retrieve on excel And Total Weight Retrieve on Database We Want To give Filter When Select Gold Then Show Only Gold entries when select silver then show only silver entries when select diamond then show oly diamond entries if select doesn't anything then show all customer  Please Help..... Attached Qv IS Given Bellow

[Anonymous]

I personally would set the equation ((Total Weight/TotalSale)*100)) as a field then create a range and use that as it creates a field you can filter on and add into tables

RangeName:

LOAD * INLINE [
    Band, From, To
    Silver, 90, 100
    Gold, 101, 110
    Diamond, 111, 500
   ];

Inner Join IntervalMatch([Equation Field]) LOAD From, To resident RangeName;

Left join (Table)
LOAD
[Equation Field],
Band
Resident RangeName;

Others may have more elegant ways to achieve it.