How to Write in script

[kulasekhar]

Hi all.

Hi,

Please do the below requirement and send back the qvw to me.

Requirement:

Col1    is in Table1

----

12345

2345

3456

4567

5678

Col 2  is in Table2

-------

12345

9876

1234

2345

4567

Result should be :

3456

5678

Unmatched values from Col1  as ResultColumn

I have changed in script.

Now write the expression in result column to solve the requirement.

Thanks,

kula

[tresesco · Accepted solution]

Like this?

Table1:
load * Inline [
Col1
12345
2345
3456
4567
5678
];

Table2:
load * Inline [
Col2
12345
9876
1234
2345
4567
];

Load
Col1 as ColResult

Resident Table1 where Not Exists (Col2, Col1);

[qlikviewwizard]

Hi kulasekhar,

Could you explain your expected result? What are those two records?

[vardhancse]

We can try using joins as well

[kulasekhar]

I want take 3 list box's one is col1 second is col2 third diplay like

Result should be :

3456

5678

Note:do not chane anthing in script level

in scprit use like that only:

Tab1:

LOAD * INLINE [

Col1

12345

2345

3456

4567

5678

];

Tab2:

LOAD * INLINE [

Col2

12345

9876

1234

2345

4567

];

[kulasekhar]

in scprit use like that only:

Tab1:

LOAD * INLINE [

Col1

12345

2345

3456

4567

5678

];

Tab2:

LOAD * INLINE [

Col2

12345

9876

1234

2345

4567

];

in dasboard one list box is col1, second one is col2, in third display Result should be:

                                                                                                                          3456

                                                                                                                           5678

[kulasekhar]

in scprit use like that only:

Tab1:

LOAD * INLINE [

Col1

12345

2345

3456

4567

5678

];

Tab2:

LOAD * INLINE [

Col2

12345

9876

1234

2345

4567

];

in dasboard one list box is col1, second one is col2, in third display Result should be:

                                                                                                                          3456

                                                                                                                           5678

[kulasekhar]

no

[robert_mika]

You can not do taht in front end

TO get all 3 tables use this

Tab1:

LOAD * INLINE [

Col1

12345

2345

3456

4567

5678

];

Tab2:

LOAD * INLINE [

Col2

12345

9876

1234

2345

4567

];

t3:

load Col2 as col3

Resident Tab2;

right join

load Col1 as col3

Resident  Tab1

where not Exists(Col2,Col1)