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 Datbase 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 not anything then show all customer  Please Help..... Attached Qv IS Given Bellow

[Anonymous]

I think you will have to create these fields in the code to be able to filter on them.

I have faced a similar problem in filtering and worked around it by doing these filters in the back end.