topic Re: compare two fields in QlikView

compare two fields

Mon, 15 Feb 2016 10:26:21 GMT

Can you help me?

I compare two fields in script.

property 'Yes' - works correctly,

but property 'No' - incorrectly.

Tanks you

Re: compare two fields

PradeepReddy — Mon, 15 Feb 2016 17:54:02 GMT

can you explain your requirement in detail?

Re: compare two fields

Chanty4u — Mon, 15 Feb 2016 17:57:14 GMT

i thnk for "no" there is data not available

Re: compare two fields

Chanty4u — Mon, 15 Feb 2016 17:59:35 GMT

or can u share the script which u hve used to create property?

Re: compare two fields

sunny_talwar — Mon, 15 Feb 2016 18:15:28 GMT

Document is repeating multiple times leading to Cartesian Product. Try this:

LOAD RowNo() as UI,

If(document = 'document2', branch) as branch1,

document

FROM

[test (1).xlsx]

(ooxml, embedded labels, table is Лист1);

left Join(1)

LOAD RowNo() as UI,

branch,

document

FROM

[test (1).xlsx]

(ooxml, embedded labels, table is Лист1);

LOAD *,

If([branch] = [branch1], 'Yes', 'No') as property

Resident 1;

DROP Table 1;

Re: compare two fields

PradeepReddy — Mon, 15 Feb 2016 18:25:18 GMT

As of my understanding, you are trying to achieve

If document= 'Document2' then Property='Yes' else No.. If this is the scenario try bellow script..

Load *,

if(document= 'Document2','Yes','No') as property

from Source;

Re: compare two fields

Gysbert_Wassenaar — Mon, 15 Feb 2016 18:29:07 GMT

'No' works properly too. All branches are possible if you select No. Check your data. Maybe you want to use INNER JOIN instead of LEFT JOIN.

Re: compare two fields

Tue, 16 Feb 2016 05:08:11 GMT

I want to get a list of 2

Re: compare two fields

Tue, 16 Feb 2016 05:14:26 GMT

I want to get a list of 2

Re: compare two fields

PradeepReddy — Wed, 17 Feb 2016 05:34:13 GMT

as per the data provided, you will get the all branches for Priority='No'.

Provide what you are trying to get achieve from the data and logic to achieve the same..