QlikSense Filter Value (If Condition ?)

[QlikEnth]

Hi Experts,

I am trying to create a new Column using some "If" Condition Logic which can be used as a Filter on Top of the Sheet, but dealing with a issue. Example my condition is (If(Country='France' OR Country='USA','Country1',if(Country='France', Country) as Column. So I am deriving a new Column based on if conditions, if the user selects Column Filter and Value=Country1, it should display France, other use case if user selects Country also it should display France.

Basically France should be display in Country1 and Country. The challenge I am Facing here is that France is already flowing to Value 'Country1' as a first if condition, how could we show France in both 'Country1' and 'Country'.

[chris_djih]

am i right that you want somethin like this?

CountryGroup	Country
Country1	France
	USA
Country	France

I would do this in a seperate table using the Inline Load:

CountryGroup:
Load * Inline [
Country, CountryGroup
France, Country
France, Country1
USA, Country 1
];