topic Re: only function in QlikView

only function

Anonymous — Tue, 05 Dec 2017 18:12:49 GMT

Hi all,

Im display a table data where i need to restrict column data based on only condition.

i dont need any group hence left group field empty.

aggr(only({<[INVESTIGATION.Inv with Activity] ={0}>}Owner2),)

aggr(only({<[INVESTIGATION.Inv with Activity] ={0}>}ID),)

I alos tried this way.

only({<[INVESTIGATION.Inv with Activity] ={0}>}Owner2)

only({<[INVESTIGATION.Inv with Activity] ={0}>}ID)

both are giving blank(-) values even though data is there...

Plz help

Thanks,

Raghav

Re: only function

its_anandrjs — Tue, 05 Dec 2017 18:25:37 GMT

Please explain bit more clear or with any sample data to explain the problem

May this

only( {1} {<[INVESTIGATION.Inv with Activity] ={0}>}Owner2)

only({1} {<[INVESTIGATION.Inv with Activity] ={0}>}ID)

Re: only function

Anonymous — Tue, 05 Dec 2017 18:58:58 GMT

t1:

owner, ID

a,1

b,2

c,4

t2:

Id,Activy

1,0

2,0

I need to filter data based on only( {1} {<[INVESTIGATION.Inv with Activity] ={0}>}Owner2)

so that i can see data only as below in table.

owner id

a 1

b 2

Re: only function

Anil_Babu_Samineni — Wed, 06 Dec 2017 02:00:14 GMT

There is no primary key in your two tables, how can you map to show them. Is there Any other field which are hidden mapping because your expression looks okay to me

Re: only function

luismadriz — Wed, 06 Dec 2017 03:01:15 GMT

Hi Raghav,

This is what I loaded (Notice the ID field, instead of using Id)

t1:

load * Inline [

owner, ID

a,1

b,2

c,4];

t2:

NoConcatenate

Load * inline [

ID,Activy

1,0

2,0];

And this is how the Table is created in the front end:

If you want to get rid of the Null, you need to not show null values or to populate all the possible activities as activity 4 is not in T2

I hope this helps,

Luis

Re: only function

luismadriz — Wed, 06 Dec 2017 03:12:07 GMT

Or something simpler:

Re: only function

jonathandienst — Wed, 06 Dec 2017 04:45:41 GMT

>>aggr(only({<[INVESTIGATION.Inv with Activity] ={0}>}Owner2),)

Syntax error - Aggr(0 needs a dimension value.

>>Only({<[INVESTIGATION.Inv with Activity] ={0}>}Owner2)

Only() returns a value if there is only one possible value for the expression and null if there is more than one.

Its not clear what you are trying to do. Perhaps you could claridy that and get more useful assistance.