Insert a field

[smilingjohn]

Hi All,

Please find the attachment of the QVW file

if you look i have a table chart and a filter called Product Area ahich has any product in that .
My requrement is to bring the O&D Product which should have below mentioned product within that .

Tho achive this within Product area i have taken the resident of the file then conacatenated it and now i have the O&D product ..

if(Match(Product_Area,'Airports','EndToEnd','Host Solutions',
'PSSPayments','Reservations','Ticketing','TTS','Ticketing_T2',),'O&DS') as Product_Area,

I am confused what i have done to achive it in the cript is corret or not ?

Thanks in Advance

[jyothish8807]

Hi John,

Try this:

if(Match(Product_Area,'Airports','EndToEnd','Host Solutions',
'PSSPayments','Reservations','Ticketing','TTS','Ticketing_T2'),'O&DS') as Product_Area,

// I have just removed an extra ','.

[smilingjohn]

Hi Jyotish, 

What i have done in the script just wanted to confirm is this the right way of achieving the extra product area ? 

Thanks 

[Anil_Babu_Samineni]

May be this?

if(Match(Product_Area,'Airports','EndToEnd','Host Solutions',
'PSSPayments','Reservations','Ticketing','TTS','Ticketing_T2'),'O&DS', Product_Area) as Product_Area

[jyothish8807 · Accepted solution]

Yes, the approach is correct. Just that you might get double count if the filters are not used correctly.

[smilingjohn]

Exactly the counts are doubled ...

This is where i am confused ...