Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 priyarane
		
			priyarane
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Community,
I am including search option on expression in straight table but values are showing wrong in the table like below
for ex:
Straight table data
Dim1|Dim2|Dim3|Expression-Sum(Sales)
A|B|C|100
A|D|X|3000
G|B|D|40
Z|ZX|C|4000
so here I am searching <3000
Then I am expecting results like
A|B|C|100
A|D|X|3000
G|B|D|40
But I am getting results like below
A|B|C|4100
A|D|X|3000
G|B|D|40
Can some one pls suggest.
-Priya
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		The value of first row changed to 4100? or is that a typo?
 priyarane
		
			priyarane
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		values are changing irrespective of search
for ex if search <3000
and dimensions are picking and according to dimension availablity values are coming in expression
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Would you be able to share a sample to show the problem
 
					
				
		
 qlikview979
		
			qlikview979
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you please share the sample app.
 priyarane
		
			priyarane
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I don't have exact application and issue, but in my sample data it is showing kind of issues.
for ex I am searching <10 then I am expecting -1 value also.
This is the only one I have issue in sample data but with actual data values are also showing incorrect as said before
 priyarane
		
			priyarane
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		if you search like <20 then you are getting 3001, -1
 
					
				
		
 qlikview979
		
			qlikview979
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Priya,
Do like this
add recno() as a dimension you will get correct result/
T1:
LOAD
recn0() as Rec,
Dim1,
Dim2,
Dim3,
Sales
FROM
[data.xlsx]
(ooxml, embedded labels, table is Sheet1);
 
					
				
		
 qlikview979
		
			qlikview979
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Here in your 3 dimension records are same for some records ,that's why it taking sum of both records .
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Seems like the issue is related to nulls in your dimension... try this
NULLASVALUE *;
Set NullValue = 'NULL';
LOAD Dim1,
Dim2,
Dim3,
Sales
FROM
[data.xlsx]
(ooxml, embedded labels, table is Sheet1);
And then try the search
