topic Re: Flag for difference between two values in QlikView

Flag for difference between two values

amigo007 — Wed, 25 Nov 2020 16:16:04 GMT

I have one table and I need to create a flag/filter to show the difference between the values in 2 columns for the same row.

My table is in the following format:

Id	Country1	Country2
1	Finland	Portugal
2	Germany	Germany
3	Morocco	Finland
4	Portugal	Morocco

So the flag can have 2 values, e.g. 'Same' and 'Different', i.e. if I click 'Same', only the 2nd row for Germany will be shown. Likewise, if I click 'Different', rows 1, 3 and 4 will be shown.

Any idea?

Thanks in advance.

Re: Flag for difference between two values

swuehl — Wed, 22 Mar 2017 12:25:00 GMT

LOAD

Id,

Country1,

Country2,

If(Country1 = Country2, 'Same', 'Different') as Flag

FROM ....;

Re: Flag for difference between two values

sunny_talwar — Wed, 22 Mar 2017 12:25:43 GMT

May be like this

LOAD Id,

Country1,

Country2,

If(Country1 = Country2, 'Same', 'Different') as Flag

FROM ...

Re: Flag for difference between two values

Anil_Babu_Samineni — Wed, 22 Mar 2017 12:25:45 GMT

May be this?

LOAD Id, Country1, Country2, If(Country1 = Country2, 'Same','Different') as Welcome Inline [

Id, Country1 ,Country2

1, Finland ,Portugal

2, Germany ,Germany

3, Morocco ,Finland

4, Portugal, Morocco

];

Re: Flag for difference between two values

swuehl — Wed, 22 Mar 2017 12:26:29 GMT

Or in an list box field expression (from <expression> dialog in field drop down on general tab):

=Aggr( If(Country1 = Country2, 'Same', 'Different') , Id)

Re: Flag for difference between two values

neha_shirsath — Wed, 22 Mar 2017 12:27:39 GMT

Hi,

Try this-

if(Country1=Country2,'Same','Diff')

Thanks,

Neha

Re: Flag for difference between two values

amigo007 — Wed, 22 Mar 2017 12:36:12 GMT

Thanks guys for your fast and efficient response.