topic Re: Insert a field in QlikView

Insert a field

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Insert a field

jyothish8807 — Mon, 10 Dec 2018 10:11:20 GMT

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 ','.

Re: Insert a field

smilingjohn — Mon, 10 Dec 2018 10:16:10 GMT

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

Re: Insert a field

Anil_Babu_Samineni — Mon, 10 Dec 2018 10:16:24 GMT

May be this?

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

Re: Insert a field

jyothish8807 — Mon, 10 Dec 2018 10:18:16 GMT

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

Re: Insert a field

smilingjohn — Mon, 10 Dec 2018 10:39:19 GMT

Exactly the counts are doubled ...

This is where i am confused ...