topic Re: How to Write in script in QlikView

How to Write in script

kulasekhar — Thu, 21 May 2015 07:03:50 GMT

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

Re: How to Write in script

tresB — Thu, 21 May 2015 07:16:35 GMT

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);

Re: How to Write in script

qlikviewwizard — Thu, 21 May 2015 08:08:55 GMT

Hi kulasekhar,

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

Re: How to Write in script

vardhancse — Thu, 21 May 2015 08:19:38 GMT

We can try using joins as well

Re: How to Write in script

kulasekhar — Thu, 21 May 2015 08:34:14 GMT

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

];

Re: How to Write in script

kulasekhar — Thu, 21 May 2015 08:57:27 GMT

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

Re: How to Write in script

kulasekhar — Thu, 21 May 2015 08:57:47 GMT

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

Re: How to Write in script

kulasekhar — Thu, 21 May 2015 09:01:13 GMT

Re: How to Write in script

robert_mika — Thu, 21 May 2015 10:35:32 GMT

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)