Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III
Contributor III

Show only records value in Table as dimension same as expression value

Hello everyone,

 

I want to ask that why the records are getting higher than the expression can anyone help me out from this,

I'm using this expression but when i entered the CUST_SNO_T with other details  in the table the records were exceeding from 42135.

 

mahnoor1279_0-1675749239209.png

 

Labels (4)
1 Reply
vinieme12
Champion III
Champion III

Your data is most likely n:n related

 n  values of table1 are associated to n values in table 2

refer example below, when you add Dim1 to a table chart, you will see 4 rows instead of 2 rows

table1:
load * inline [
Dim1,Dim2
A,a
A,b
B,a
B,b
];


table2:
load * inline [
Dim2,ID,field1
a,1,2302
b,2,3042
];

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.