Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

Table visualization

I am using the below expression in my table

if([Table Source]=('WHINH301') and ("T$LTRL"=1) and ((len(trim("T$BOLA"))>0)),Sum({<[Ship_Date_GMT_Updated]={"<=$(vLastmonthdate)"},[Arrive_Date_GMT_Updated]={">$(vLastmonthdate)"}>} Quantity)
,if([Table Source]=('WHINH301') and ("T$LTRL"=2) and ((len(trim("T$BOLA"))>0)),Sum({<[Ship_Date_GMT_Updated]={"<=$(vLastmonthdate)"}>} Quantity)
))

But when I remove a field named [SHID] my Quantity value changes, even though I haven't used [SHID] on my front end.

Can anyone tell why?

3 Replies
vinieme12
Champion III
Champion III

Where are you removing [SHID] from, is it a dimension in your chart? a filter applied? 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
risabhroy_03
Partner - Creator II
Partner - Creator II
Author

I am removing SHID from my table visualization.

Yes, it is a dimension in my chart.

vinieme12
Champion III
Champion III

that means your values are simply aggregating at a different level now,

 

also do not use keyfields in your charts

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