QlikSense Filter Value (If Condition ?)

QlikEnth — Thu, 10 Feb 2022 14:57:17 GMT

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

Re: QlikSense Filter Value (If Condition ?)

chris_djih — Fri, 11 Feb 2022 10:56:15 GMT

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 ];

topic Re: QlikSense Filter Value (If Condition ?) in App Development

QlikSense Filter Value (If Condition ?)

Re: QlikSense Filter Value (If Condition ?)