Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kshitijas
New Contributor III

How to use 'Equal to' in set expression?

hi,

Could you please let me know how to use “equal to” in the set expression.

eg. I have a region column and wana take only those region which i want to see in the list . How do i do that?

eg. for NOT EQUAL we use '<>' so for EQUAL what we can use in set expression?

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: How to use 'Equal to' in set expression?

In the load script, you can try this:

LOAD YourFieldNames,

FROM

Where Match(Region, 'Region1', 'Region2', 'Region3');

4 Replies
MVP
MVP

Re: How to use 'Equal to' in set expression?

I would just do like this:

{<Region = {'Region1', 'Region2', 'Region3'}>}

kshitijas
New Contributor III

Re: How to use 'Equal to' in set expression?

Hey ,

           I tried putting this expression but it isnt working..Can u tell how to use it in Load editor using a where clause?

MVP
MVP

Re: How to use 'Equal to' in set expression?

In the load script, you can try this:

LOAD YourFieldNames,

FROM

Where Match(Region, 'Region1', 'Region2', 'Region3');

galax_allu
Valued Contributor

Re: How to use 'Equal to' in set expression?

Hi,

In editor , you can write like this ...

But for the SET EXPRESSION what  sunny said should be correct !!!!

LOAD * INLINE [

    Country, Total Debt, 0-60, 60-180, 180+

    USA, 152, 123, 23, 6

    Canada, 250, 100, 100, 50

    UK, 170, 170, 0, 0

    Germany, 190, 0, 0, 190

    Japan, 90, 15, 25, 50

    France, 225, 77, 75, 73

]

Where(Country='USA');