topic Re: Single Val in table in QlikView

Single Val in table

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

Hi all ,

I have one issue in my data

I have two tables like below ,

Tabl:

LOAD * INLINE [

ID, Sub ID, Val

1, 1.1, 873

1, 1.2, 9267

1, 1.3, 28

2, 2.1, 6726

2, 2.2, 6725

3, 3.1, 78

3, 3.2, 7256

3, 3.3, 2678

];

Tab2:

LOAD * INLINE [

ID, Val 2

1, 893

2, 9038

3, 7823

];

Second table is linking with ID only .But i add these two fields sum in straight table with ID, Sub ID as dimensions and Val and Val 2 as Expression

For Val 2 i don't have bifurcation for Val 2 against Sub ID. Bcoz of that reason val 2 is geeting repeate all over.

I m planing to some like below : Is that possible

subbareddykm — Fri, 13 Jan 2017 11:22:07 GMT

pFA...

khalander — Fri, 13 Jan 2017 11:28:15 GMT

Hi,

Try this below condition in your second expression in straight table.

=if(isnull(aggr(sum([Val 2]),ID)),0,aggr(sum([Val 2]),ID))

subbareddykm — Fri, 13 Jan 2017 11:57:30 GMT

I have 20+ dimensions are there , Will this work on that ?

bcoz, i we used Aggr on ID only right.