Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Single Val in table

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

 

IDSub IDVal 1Val 2
3363117754
11.1873893
11.292670
11.3280
22.167269038
22.267250
33.1787823
33.272560
33.326780
1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

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

View solution in original post

3 Replies
Highlighted
Creator II
Creator II

pFA...

Highlighted
Creator II
Creator II

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

View solution in original post

Highlighted
Creator II
Creator II

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

bcoz, i we used Aggr on ID only right.