Solved: Re: Not equal to in LET - Qlik Community

New-Qlik · ‎2019-11-18

Hello,

How to write not equal to in LET variable .

I want an variable like

LET vl.name <> 'AAA,BBB,CCC,DDD' using <> and minus '-' doesnot work.

TIA

Arthur_Fong · ‎2019-11-19

Try this:

Script:

Set vl.name = 'AAA, BBB,CCC';

Expression:

sum({<[Dim1]-={$(vl.name)}>}[Measure])

View solution in original post

Anil_Babu_Samineni · ‎2019-11-18

Perhaps

LET Variable1 = '=Not Wildmatch([vl.name], 'AAA', 'BBB')';

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Arthur_Fong · ‎2019-11-18

Or maybe try:

Set var1='AAA,BBB,CCC,DDD' ;

LOAD *

RESIDENT <TABLENAME>

WHERE <COLUMNNAME> <>$(var1);

New-Qlik · ‎2019-11-19

I used Let vl.name = 'AAA, BBB,CCC' and in set analysis while calling this variable i used minus '-'

Arthur_Fong · ‎2019-11-19

Try this:

Script:

Set vl.name = 'AAA, BBB,CCC';

Expression:

sum({<[Dim1]-={$(vl.name)}>}[Measure])

New-Qlik · ‎2019-11-20

Thanks for replying .Yes i did same and it worked