Discussion Board for collaboration on QlikView Scripting.
I have some in appropriate data, and I want to correct three fields.
Here is the sample data, and correction (in blue)
I hope you Have Party Name wise Correct data in following way:
Party Name Correct City Correct State
So Use apply Map Two Times As Below:
[Correct City ]
[Correct State ]
Use apply Map into your base table two times one for city and one for state
ApplyMap('CityMapping','[Party ID]',City) as CorrectCity,
ApplyMap('StateMapping','[Party ID]',State) as CorrectState
Thanks for reply, i have data like this:-
but i dont have correct data with me that i shown in blue
If(State ='KARNATAKA', 'BANGALORE',If(State ='DELHI', 'DELHI', City)) as City,
If(City ='DELHI', 'DELHI', State) as State,
If(City ='DELHI', 'ASIA', Continent) as Continent
i want to map party name wise state and city because i have many city and state is 'COMMON'
i want is if i select party_name "b" i want city as bangalore and State as Karnataka, i hope u understand my issue,
But you Know what correct fields against what party name.
Is it possible to share the data here?
You can use DynamicUpdateCommand in Macro like this
Sub Update SET Result = ActiveDocument.DynamicUpdateCommand ("UPDATE Table SET city = 'BANGALORE' WHERE factory='G' and party_name='b' ") End Sub
This Macro works in Ajax Mode as well.
You can link this Trigger on OnOpen Doc or Botton Action.
You must create Master according to your party name wise which you want to select manually.
Party Name City State
and apply as i mentioned above.
can you please give me a small example?