topic Re: Qlik: If condition Col 1 vs Col 2 in App Development

Qlik: If condition Col 1 vs Col 2

tsachdev421 — Mon, 15 Aug 2022 16:13:17 GMT

>> If there is a text value In Column 2 (other than '-' or Null), value in Column 2 should be displayed as output.
>> If Col 1 has value and Col 2 is Null or '-', value in Col 1 should be displayed as o/p.
>> If Col 1 and Col 2 both has text value. text in Col 2 should be displayed as o/p

Logic Used: if ("Col 1" = '-' or len(trim("Col 1")) = 0, "Col 2", "Col 1" )

Note: Above if Condition requires modification.

Re: Qlik: If condition Col 1 vs Col 2

Taoufiq_Zarra — Mon, 15 Aug 2022 21:57:00 GMT

@tsachdev421 if I understood correctly

you can use this :

load *,if(len(trim([Column 2]))>0,[Column 2],if(len(trim([Column 1]))>0,[Column 1])) as output; load replace([Column 1],'-','') as [Column 1] ,replace([Column 2],'-','') as [Column 2] inline [ Column 1,Column 2 Text1,Text2 Text3, Text4,- Text5,Text6 Text7,- Text8,Text9 -,Text10 -,- ]

output:

Re: Qlik: If condition Col 1 vs Col 2

rwunderlich — Mon, 15 Aug 2022 23:55:39 GMT

How about:

Coalesce([Column 2], [Column 1])

-Rob