exclude some value from dimension

[everest226]

HI i have a chart with QVW name as a dimension,  which shows how manny user and session each QVW has,, but i want to exclude some QVW name from that chart,

like

i dont want Finance.qvw   and Home graph.qvw  in the chart

[sunny_talwar]

May be this:

Replace(FieldName, '.qvw', '')

[everest226]

hi sunny i am not trying to replace the field , i was trying not to include Finance.qvw   and Home graph.qvw  in the chart

[vishsaggi · Accepted solution]

May be this:

= IF(Not Match(FieldName, 'Finance.qvw', 'Home Graph.qvw') , FieldName)

[sunny_talwar]

Misunderstood the requirement, but vishsaggi‌'s response should work for you

[everest226]

Thanks stalwar1‌ you always been helpful